The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Appending datasets of one country for several years
Re: Appending datasets of one country for several years [message #15756 is a reply to message #15442] Mon, 10 September 2018 20:45 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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.
 
Read Message
Read Message
Read Message
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:
  


Current Time: Thu Mar 28 20:23:39 Coordinated Universal Time 2024