Re: Merge datasets [message #19199 is a reply to message #19151] |
Fri, 08 May 2020 14:45 |
Bridgette-DHS
Messages: 3199 Registered: February 2013
|
Senior Member |
|
|
Following is a response from DHS Research & Data Analysis Director, Tom Pullum and Senior DHS Specialist, Kerry MacQuarrie:
The following should work for merging the PR and IR in the NFHS4. Let us know if it does not do what you want.
* Prepare IR file for merge
use IR.dta, clear
gen in_IR=1
rename v024 hv024
rename v001 hv001
rename v002 hv002
rename v003 hvidx
sort hv024 hv001 hv002 hvidx
save IRtemp.dta, replace
* Prepare PR file for merge
use PR.dta, clear
gen in_PR=1
sort hv024 hv001 hv002 hvidx
* Merge PR with IR
merge hv024 hv001 hv002 hvidx using IRtemp.dta
tab _merge
keep if _merge==3
drop _merge
From the Guide to DHS Statistics (p.15.21), v633b is the "Number of women (or men) age 15-49 who believe that a woman is justified in refusing to have sexual intercourse with her husband if she knows that he has sexual intercourse with other women (women: v633b = 1; men: mv633b = 1) .
This variable is an attitudinal variable. To get at behavior regarding having sexual intercourse with someone other than one's spouse/cohabiting partner in the past 12 months, see variables v767a-c and mv767a-c.
We encourage frequently consulting the Guide to DHS Statistics, particularly in the data exploration phase of any analysis project.
|
|
|