| Re: Merging of NFHS-4 dataset [message #17956 is a reply to message #17955] |
Thu, 25 July 2019 16:33  |
Bridgette-DHS
Messages: 3029
Registered: February 2013
|
Senior Member |
|
|
Following is another response from DHS Research & Data Analysis Director, Tom Pullum:
I believe the problem is that sh34 and sh36 in the PR file are the religion and caste of the household head, not the respondent. For individual respondents they are given by v130 and v131 for women and mv130 and mv131 for men. Also, hv115 is an initial statement of marital status, during the household interview, but when the woman or man is interviewed individually,v501 and mv501 are considered to be more accurate than hv115. The following lines will give you a file that I think matches Table 3.1 Use v005 for weighted distributions for women and mv005 for men.
* Prepare IR and MR files
use v001 v002 v003 v005 v024 v013 v106 v130 v131 v501 using "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAIR74FL.DTA", clear
rename v001 hv001
rename v002 hv002
rename v003 hvidx
rename v024 hv024
save e:\DHS\DHS_data\scratch\IAIR74temp.dta, replace
use mv001 mv002 mv003 mv005 mv024 mv013 mv106 mv130 mv131 mv501 using "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAMR74FL.DTA", clear
rename mv001 hv001
rename mv002 hv002
rename mv003 hvidx
rename mv024 hv024
append using e:\DHS\DHS_data\scratch\IAIR74temp.dta
sort hv024 hv001 hv002 hvidx
save e:\DHS\DHS_data\scratch\IAIRMR74temp.dta, replace
* Prepare PR file and merge
use hv001 hv002 hvidx hv024 sh34 sh36 hv104 hv115 hv106 using "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAPR74FL.DTA", clear
sort hv024 hv001 hv002 hvidx
merge hv024 hv001 hv002 hvidx using e:\DHS\DHS_data\scratch\IAIRMR74temp.dta
tab _merge
keep if _merge==3
drop _merge
* Get distributions
tab1 v130 mv130 if mv013~=8
tab1 v131 mv131 if mv013~=8
tab1 v501 mv501 if mv013~=8
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
