The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Issue merging household and individual (women's) file
Issue merging household and individual (women's) file [message #13600] Mon, 27 November 2017 19:28
ec2017 is currently offline  ec2017
Messages: 3
Registered: October 2017
Member
I am having some trouble interpreting the results of my merge of the household and individual files for Tanzania 2015-2016. According to the DHS Final Report for Tanzania, there were 12,563 households that were successfully interviewed. At these households, 13,266 women were successfully interviewed. When I merged the household and women's data files, all 13,266 women matched to a household (as expected). However, the merge reported that there were 3,033 households for which no woman was found.

Problems:
• This figure (3,033) does not match the number of households with 0 women present; according to the household file, there should be 2,907 households for which no woman was found.
• When I load my merged file, it shows that there are 16,299 observations instead of the 13,266 women I expected to see. It appears that somehow, 13,266 and 3,033 are getting added together to result in 16,299.
• The mystery 3,033 observations have missing values for almost all variables.

I have two questions. Why are there 3,033 households for which no woman was found instead of 2,907? How should I handle the 3,033 observations?

Here is my Stata code for the merge in case it is helpful:

*import household file to rename variables
clear
use "C:\Users\student\Desktop\TZHR7HFL.DTA"

*generate variables for the match in the household file
gen v001=hv001
gen v002=hv002

*sort household file
sort v001
sort v002

*save revised household dataset
save "C:\Users\student\Desktop\TZHR7HFL_sorted.DTA", replace

*open base data file (women's)
clear
use "C:\Users\student\Desktop\TZIR7HFL.DTA"

*sort women's file
sort v001
sort v001

*save revised women's file
save "C:\Users\student\Desktop\TZIR7HFL_sorted.DTA", replace

*merge the two files
clear
use "C:\Users\student\Desktop\TZIR7HFL_sorted.DTA"

*merge many to one using v001 and v002
merge m:1 v001 v002 using "C:\Users\student\Desktop\TZHR7HFL_sorted.DTA"

*check the merge
tab _merge

Thank you very much for any assistance you can provide.
Previous Topic: Merge CR and IR
Goto Forum:
  


Current Time: Wed Dec 13 02:31:43 Eastern Standard Time 2017