Following is a response from Senior DHS Stata Specialist, Tom Pullum:
I checked what you did with the Stata lines given below. I agree with what you got. I recommend that you construct a new weight that is v005 for the women and mv005 for the men. I call it v005_mv005 but you could call it whatever you want.
use e:\DHS\DHS_data\PR_files\KEPR70FL.dta, clear
keep hv001 hv002 hvidx hv005 hv101 hv104 hv105
keep if hv101==1
sort hv001 hv002 hvidx
save e:\DHS\DHS_data\scratch\PRtemp.dta, replace
use e:\DHS\DHS_data\IR_files\KEIR70FL.dta, clear
keep v001 v002 v003 v005 v481
rename v001 hv001
rename v002 hv002
rename v003 hvidx
tab v481,m
gen sex=2
save e:\DHS\DHS_data\scratch\IRtemp.dta, replace
use e:\DHS\DHS_data\MR_files\KEMR70FL.dta, clear
keep mv001 mv002 mv003 mv005 mv481
rename mv001 hv001
rename mv002 hv002
rename mv003 hvidx
tab mv481,m
rename mv481 v481
gen sex=1
save e:\DHS\DHS_data\scratch\MRtemp.dta, replace
append using e:\DHS\DHS_data\scratch\IRtemp.dta
sort hv001 hv002 hvidx
merge hv001 hv002 hvidx using e:\DHS\DHS_data\scratch\PRtemp.dta
tab _merge
keep if _merge==3
drop _merge
tab v481 sex,m
gen v005_mv005=.
replace v005_mv005==mv005 if sex==1
replace v005_mv005==v005 if sex==2
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
