The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Data » IPUMS Demographic and Health Surveys (IPUMS-DHS)  » Merging IDHS and DHS household level files
Merging IDHS and DHS household level files [message #4199] Wed, 15 April 2015 14:32 Go to next message
anj_user is currently offline  anj_user
Messages: 1
Registered: April 2015

I am trying to link the two and am having trouble. Your info sheet asks that I use "hhid" to merge, but that does not seem to work even if I use v001 and v002 to merge. I also tried to create the "idhshid" variable in my household level sets, but could not do the same for the IDHS. How would you suggest I merge the two? Especially given that I am trying to merge household level files for all countries included in the IDHS at the moment.

Re: Merging IDHS and DHS household level files [message #4209 is a reply to message #4199] Thu, 16 April 2015 23:22 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 598
Registered: January 2013
Senior Member
Can you let us know which surveys and datasets you are using as that can make a difference. From the variables you reference, there is perhaps an issue as hhid is a variable from the household data, but v001 and v002 are from the individual women's data (not the household data), so I wouldn't expect them to merge easily. Can you tell me which DHS dataset you are using (and which software you are using), and then which variables you selected through IDHS?

Can you also tell us if there is a reason you are trying to merge datasets from the IDHS and the regular DHS datasets? They were really designed for users to use one or the other. If you can let us know this information we should be able to direct you how to merge the datasets.
Re: Merging IDHS and DHS household level files [message #14832 is a reply to message #4209] Tue, 08 May 2018 11:05 Go to previous message
boyle014 is currently offline  boyle014
Messages: 36
Registered: December 2015
Location: Minneapolis
Quick follow up to this thread... Household variables are accessible from all the units of analysis in IPUMS-DHS. (That's been true for several years.) Simply choose your unit of analysis and use the Topics drop-down menu or the Search function to find the variables that interest you. The + sign by the variable name adds it to your data extract.

The units of analysis current in IPUMS-DHS include women, children, births, and household members--known in DHS parlance as the IR, KR, BR, and PR files.

Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
Previous Topic: Scope of IPUMS-DHS, as of April 2018
Next Topic: Household members as unit of analysis
Goto Forum:

Current Time: Wed Jul 18 10:24:50 Eastern Daylight Time 2018