The DHS Program User Forum: Dataset use in Stata » appending Jordan DHS 2007 2012 2017

Home » Data » Dataset use in Stata » appending Jordan DHS 2007 2012 2017 (DHS for different years have same Case ID)

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

appending Jordan DHS 2007 2012 2017 [message #26341]

Thu, 09 March 2023 04:31

afatsum (read it reverse) is currently offline

afatsum (read it reverse)
Messages: 1
Registered: March 2023

Member

Hi,

I want to append 2007, 2012, 2017 DHS of Jordan but these crosssections use same caseIDs. When I check Duplicates I get a lot. Can u help me so that I can append with unique CaseIDs.

Regards
Mustafa

Report message to a moderator

Re: appending Jordan DHS 2007 2012 2017 [message #26343 is a reply to message #26341]

Thu, 09 March 2023 13:25

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

One way to do this, after appending the IR files, for example, would be to enter this statement in Stata: "egen CASEID=group(v000 caseid)". Then CASEID would be a unique identifier.

In these surveys, v000 is JO5 in the 2007 survey, JO6 in the 2012 survey, and JO7 in the 2017 survey. The 5, 6, and 7 indicate the version of the coding manual. Sometimes, two consecutive surveys in the same country will use the same version of the coding manual and v000 will not uniquely identify the survey, but for these surveys you will be ok. More generally, you could define a variable "survey" that is different for each survey and then use "egen CASEID=group(survey caseid)".

Report message to a moderator

Previous Topic:	Which recode file to choose IR-KR-BR
Next Topic:	Jordan dataset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 21 12:57:11 Coordinated Universal Time 2024