The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Merge datasets (NFHS4 Individual and Household datasets)
Re: Merge datasets [message #19199 is a reply to message #19151] Fri, 08 May 2020 14:45 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3130
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.
 
Read Message
Read Message
Previous Topic: Hosehold Member
Next Topic: Queries on calendar data in NFHS-4
Goto Forum:
  


Current Time: Tue Aug 13 12:19:45 Coordinated Universal Time 2024