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 message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 566
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.
Next Topic: 2014 Kenya Demographic Data
Goto Forum:

Current Time: Sun Apr 22 16:30:14 Eastern Daylight Time 2018