The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merging two rounds

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

Merging two rounds [message #28048]

Mon, 06 November 2023 09:19

eceaydin
Messages: 3
Registered: October 2023

Member

Hi there,

Is it possible to merge two rounds of the KR files for the same country? I am looking at variables over time and would like to see them on the same file to see change in levels of child marriage etc. Could you help me with this? What variables would i need to use?

Best,
Ece Aydın

Report message to a moderator

Re: Merging two rounds [message #28051 is a reply to message #28048]

Mon, 06 November 2023 09:52

Bridgette-DHS
Messages: 3043
Registered: February 2013

Senior Member

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

You are talking about appending the two surveys into a single long file, rather than merging them case-by-case, which is not possible, because DHS surveys are independent of one another. In Stata the command is "append", and you can get its syntax with "help append". It will help to define a variable "survey" with survey=1 in the first survey and survey=2 in the second survey. Otherwise you can use the interview year (v007) to distinguish between the surveys. In the analysis, you would treat "survey" as a covariate, in the same way as place of residence (v025), for example.

Report message to a moderator

Previous Topic:	Merging IR and PR - Indonesia 1987
Next Topic:	Child nutrition and spousal violence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 05:17:06 Coordinated Universal Time 2024