| Creating Couples' file from IR and MR datasets for India [message #25157] |
Wed, 07 September 2022 23:42  |
dcpathak
Messages: 8
Registered: September 2022
|
Member |
|
|
Hello,
I want to create a couples dataset by merging IR and MR files. I can use the couples' recode dataset already provided, but I need some missing variables. The main purpose is to study domestic violence, and NFHS says one should use an IR file to study domestic violence. I just need a few variables from the MR file to merge with the IR file.
The state codes I used are:
use "D:\DHS data\NFHS 5\Individual & Woman\IAIR7BFL.DTA"
rename v001 mv001
rename v002 mv002
rename v034 mv003
rename v024 mv024
save "D:\DHS data\NFHS 5\Men\wrtemp.dta"
duplicates report mv001 mv002 mv003 mv024
sort mv001 mv002 mv003 mv024
duplicates drop mv001 mv002 mv003 mv024, force
save, replace
clear
use "D:\DHS data\NFHS 5\Men\IAMR7BFL.DTA"
sort mv001 mv002 mv003 mv024
merge 1:1 mv001 mv002 mv003 mv024 using "D:\DHS data\NFHS 5\Men\wrtemp.dta"
save "D:\DHS data\NFHS 5\Men\wrmen.dta"
The number of observations in the couples file, as provided by NFHS-5, is 57,693, whereas my merged files have 57,923 observations. Where am I making an error? Any help/suggestions would be deeply appreciated.
Regards,
dcpathak
|
|
|
|
Members
Search
Help
Register
Login
Home
