The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » combinning three files into one file
combinning three files into one file [message #11297] Wed, 30 November 2016 08:17 Go to next message
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
Re: combinning three files into one file [message #11499 is a reply to message #11297] Tue, 03 January 2017 16:08 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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.

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


Current Time: Fri Mar 29 05:24:13 Coordinated Universal Time 2024