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
Re: Issue merging household and individual (women's) file [message #13831 is a reply to message #13600] Mon, 08 January 2018 15:50 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

In this survey, there were 2907 households with no women in them. However, some eligible women were not actually interviewed. This can happen because of a refusal, or unavailability, or age is later determined to be out of range, etc. I suggest that you do your merge a little differently, merging the IR file with the PR file rather than the HR file. If you run the lines given below, you will find that there were 126 households in which there was one or more eligible women who did not make it into the IR file. 2907+126=3033; that's where the 3033 comes from. There were 116 households in which there was one eligible women and she dropped out; 7 households in which there were 2 eligible women and both of them dropped out; and 3 households in which there were 3 eligible women and all three dropped out.

set more off
set maxvar 10000
use e:\DHS\DHS_data\IR_files\TZIR7HFL.dta, clear
sort v001 v002 v003
save e:\DHS\DHS_data\scratch\TZPRtemp.dta,  replace

use e:\DHS\DHS_data\PR_files\TZPR7HFL.dta, clear
gen v001=hv001
gen v002=hv002
gen v003=hvidx
sort v001 v002 v003
merge v001 v002 v003 using e:\DHS\DHS_data\scratch\TZPRtemp.dta

tab hv117 _merge

gen elig_women_not_interviewed=1  if hv117==1 & _merge==1
gen elig_women_interviewed=1  if hv117==1 & _merge==3

collapse (sum) elig*, by(v001 v002)
tab elig_women_not_interviewed  if elig_women_interviewed==0

Read Message
Read Message
Read Message
Previous Topic: merging HR and IR
Next Topic: Merging Rwanda DHS 1992 without b16
Goto Forum:

Current Time: Fri Apr 3 18:17:29 Eastern Daylight Time 2020