| Re: Issue merging household and individual (women's) file [message #13831 is a reply to message #13600] |
Mon, 08 January 2018 15:50   |
Bridgette-DHS
Messages: 3038
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
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
