The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging African countries and discrepancy between births and household file
Merging African countries and discrepancy between births and household file [message #6957] Thu, 06 August 2015 14:06 Go to previous message
nholla is currently offline  nholla
Messages: 13
Registered: May 2015
Member
Hello DHS, I had two questions that I could use your help on!

I'm trying to create an overarching analytic file across all sub-Saharan African countries for 3 different years using the birth, household member, and women's files. Is there a recommended approach to doing this/are there any potential roadblocks that I should be aware of? This is what I had planned on doing (I'm using stata):

1. Merge different file types for a particular country for a particular year.
2. Append all pertinent years of interest for a specific country.
3. Append all countries together.

I'm trying to merge each child in the births file to the household member file, using the "child line number in household" variable as a reference. However, I see that there are some children that are "not listed in household." Why are not all of the births not accounted for in the household? I initially thought this might mean the child passed away, but these are recorded missing. In Ghana 2008, for example, this occurs around 3000 times.

Thanks for your help!
 
Read Message
Read Message
Previous Topic: merging children's file and wealth index
Next Topic: Problems with merging Namibia 2013 IR MR and HIV data
Goto Forum:
  


Current Time: Sat Dec 28 15:23:32 Coordinated Universal Time 2024