The DHS Program User Forum: India

Home » Countries » India » Merge datasets (NFHS4 Individual and Household datasets)

Show: Today's Messages :: Show Polls :: Message Navigator

Merge datasets [message #19151]

Tue, 28 April 2020 17:32

vpatil
Messages: 9
Registered: March 2019

Member

Hi. I want to merge NFHS 4 Individual and Household datasets but I am unable to do so. I followed the thread of discussion on this topic and have tried all that has been suggested such as creating v001, v002, and v003 variables in household datasets and including v024 in the sort command but no success. I did post this question before too but I guess it went to another site.

Also, I have a question about variable v633a in the individual dataset. Please can you explain what it means? In the questionnaire, it is asked as a part of whether the wife believes that she can refuse sex if the husband has other women but in the do-file, it is mentioned as 'reason to refuse sex: husband has other women'. I want to create a variable for an extramarital affair and am not sure if this variable is the right one.

Report message to a moderator

Re: Merge datasets [message #19199 is a reply to message #19151]

Fri, 08 May 2020 14:45

Bridgette-DHS
Messages: 3230
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.

Code: [Select all] [Show/ hide]

* 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.

Report message to a moderator

Previous Topic:	Hosehold Member
Next Topic:	Queries on calendar data in NFHS-4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 27 07:23:40 Coordinated Universal Time 2025