The DHS Program User Forum: Merging data files » Appending datasets of one country for several years

Home » Data » Merging data files » Appending datasets of one country for several years

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Appending datasets of one country for several years [message #15756 is a reply to message #15442]

Mon, 10 September 2018 20:45

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from Senior DHS Specialist, Tom Pullum:

Yes, you definitely need to construct unique ID codes for the clusters (PSUs) in the separate rounds. I suggest the following. First, give separate survey numbers to the 2002 and 2012 rounds, during the appending. For example, say that they are survey=1 and survey=2. You then construct a unique PSU ID with "egen clusterid=group(survey v001)". Similarly, if v023 is the stratum variable, you can construct a unique stratum ID with "egen stratumid=group(survey v023)". Then you put clusterid and stratumid in the appropriate places in svyset. There have been other posts on this topic.

Report message to a moderator

[Message index]

		Appending datasets of one country for several years By: Kamola on Mon, 23 July 2018 01:14
		Re: Appending datasets of one country for several years By: Bridgette-DHS on Mon, 10 September 2018 20:45
		Re: Appending datasets of one country for several years By: boyle014 on Tue, 11 September 2018 12:56

Previous Topic:	Duplicates in KR file and Empty values for HV005 after merging.
Next Topic:	No of children in the household for diarrhoeal prevalence at household level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 16 09:25:16 Coordinated Universal Time 2025