The DHS Program User Forum: Merging data files » combinning three files into one file

Home » Data » Merging data files » combinning three files into one file

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

combinning three files into one file [message #11297]

Wed, 30 November 2016 08:17

Agbor
Messages: 3
Registered: July 2016

Member

Hi all,

Please I will like your help. I am working with the cameroon DHS women Survey for the years 1998, 2004 and 2011. I would like to put all the three survey into one file for analysis in stata
Please can someone help me on how to go about this?

Thank you for your help in advance

Report message to a moderator

Re: combinning three files into one file [message #11499 is a reply to message #11297]

Tue, 03 January 2017 16:08

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

You have to be careful what you do with a combined file. It will not refer to a well-defined population. But if you insist on doing this, you should first reduce each file to the variables you want. Then open one of them; add the second with "append using...."; then add the third with "append using....." You can distinguish between the surveys with v001 or v007 or you can add some other identifier such as "survey" that is 1 for the first survey, 2 for the second survey, and 3 for the third survey.

Report message to a moderator

Previous Topic:	Merging several datasets
Next Topic:	Combining mother's info on child row in PR file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Dec 21 13:30:43 Coordinated Universal Time 2024