Merge IR and MR file DHS 2022 Nepal [message #27868] |
Sat, 14 October 2023 21:17 ![Go to next message Go to next message](/theme/default/images/down.png) |
JDevkota
Messages: 2 Registered: May 2018 Location: Brussels
|
Member |
|
|
Hi,
I'm working on the mental health data of DHS 2022 Nepal. I want to get all the data of GAD-7 and PHQ-9 of all interviewed Males and females.
For that, I need to merge the IR (Individual Women's Data - Individual Recode (IR)) and MR (Men's Data - Male Recode (MR)) files to get all variables start with (MTH). Could you please guide me on how can I get it?
Thank you!
JDevkota
|
|
|
Re: Merge IR and MR file DHS 2022 Nepal [message #27887 is a reply to message #27868] |
Tue, 17 October 2023 12:28 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Janet-DHS
Messages: 810 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
I believe you want to append, rather than merge. In an append the women and men in the IR and MR files will remain as individuals on separate records. The following Stata lines will construct the file. You need to change the paths and the working folder and decide what covariates (besides v0*) to include. The "sex" variable is constructed in the same way as hv104 in the PR file.
If what you want is a pairing of women and men into couples, you would use the CR file, which is one of the standard recode files. In that file, the mth variables refer to the woman and the mmth variables refer to the man. The CR file only includes women and men who name each other as partners.
* Nepal 2022 DHS
* Construct a file with the mental health variables for all women and men
* Keep the needed covariates; illustrated here with just the v0* variables
* Specify a workspace
cd e:\DHS\DHS_data\scratch
use "...NPIR82FL.DTA", clear
keep v0* mth*
gen sex=2
save NPtemp.dta, replace
use "...NPIR82FL.DTA", clear
rename m* *
keep v0* mth*
gen sex=1
append using NPtemp.dta
sort v001 v002 v003
label define sex 1 "Male" 2 "Female"
label values sex sex
* Sort here is optional
sort v001 v002 v003
* save this file with a new name
|
|
|