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
Append IPUMS_Merge to DHS Data [message #17804] Wed, 05 June 2019 19:50 Go to next message
Yawo is currently offline  Yawo
Messages: 13
Registered: February 2019
Member

Hello, Thanks for your recent updates re IPUMS. I have a question about linking merged data produced by IMPUMS to similar dataset from the DHS (cross-posted on IPUMS forum on IDHS site).

I am examining HIV risk behaviors in sub-Saharan Africa, and will be using data from the following countries:

Angola
Benin
Burkina Faso
Burundi
Cameroon
Chad
Congo
Congo Democratic Republic
Cote d'Ivoire
Eswatini
Ethiopia
Gabon
Gambia
Ghana
Guinea
Kenya
Lesotho
Liberia
Malawi
Mali
Mozambique
Namibia
Niger
Rwanda
Senegal
Sierra Leone
South Africa
Tanzania
Togo
Uganda
Zambia
Zimbabwe

I plan to use IPUMS to create a pooled dataset containing selected/harmonized variables of interest. However, IPUMS currently does not have data for the following countries (unless I am mistaken):

Chad
Gabon
Liberia
Sierra Leone
Togo
Swaziland/Eswatini

If this is the case, my plan is to go ahead generate the pooled dataset using IPUMS. I have access to the data for these subset of six countries. How do I append them to the IPUMS harmonized version and ensure that is is truly harmonized - with variable and value/labels?

thanks - Yawo
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 next message
boyle014 is currently offline  boyle014
Messages: 60
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
Re: Append IPUMS_Merge to DHS Data [message #17810 is a reply to message #17806] Mon, 10 June 2019 09:50 Go to previous message
Yawo is currently offline  Yawo
Messages: 13
Registered: February 2019
Member
Dr. Boyle: good morning. Thanks very much for your response. I understand the process, and will execute it as advised.

I have a related question: do i have to go through de-normalizing the weights since I am pooling the data for recent surveys only?

And if so, how will these work?

Do I denormalize after I've merged both IPUMS and the DHS data or before/separately, and then merge them.

Thanks - Yawo

Previous Topic: New data from Jordan, Nepal, Pakistan, and South Africa
Goto Forum:
  


Current Time: Mon Jun 17 13:48:50 Eastern Daylight Time 2019