The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » IPUMS Demographic and Health Surveys (IPUMS-DHS)  » Append IPUMS_Merge to DHS Data
Re: Append IPUMS_Merge to DHS Data [message #17806 is a reply to message #17804] Thu, 06 June 2019 19:37 Go to previous messageGo to previous message
boyle014 is currently offline  boyle014
Messages: 78
Registered: December 2015
Location: Minneapolis
Senior Member
Dear Yawo,

Great question. There are multiple ways to do this, but this is my recommendation. I would use the IPUMS DHS data first. Once you're happy with your variables and analysis, then add in The DHS Program samples.


To add in the other samples, first find The DHS Program variable names for the variables you're using. These appear at the top of all the documentation pages at IPUMS DHS. (You get to the documentation pages by clicking on a variable's name). For example, the IPUMS DHS variable "aidgetbite" is V754JP in the original DHS Program files. Download the six additional surveys from The DHS Program website and retain the relevant variables.


In Excel, create a sheet for each variable. In the first column, include the IPUMS DHS codes and value labels; put the IPUMS DHS variable name at the top. In the second column, include the Chad codes and labels with The DHS Program variable name at the top. In the third column, include the Gabon codes and labels, and so forth. Use the Excel sheets to recode the DHS variables to match the IPUMS DHS variables. Do this within each file. Then append the revised files to your IPUMS DHS file.

This should work. Just let us know if you have any more questions.


Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: New data from Jordan, Nepal, Pakistan, and South Africa
Next Topic: Complex weights for pooling cross country IPUMS-DHS data
Goto Forum:
  


Current Time: Thu Apr 25 15:31:28 Coordinated Universal Time 2024