| Merging IR and MR Kenya 2022 (2022 KDHS) [message #28346] |
Mon, 18 December 2023 16:04  |
bakerchowdhury
Messages: 23
Registered: April 2014
|
Member |
|
|
Hello everyone,
I am analyzing 2022 Kenya DHS. To do all women and men as unit of analysis I would like to add the women (IR) and men's (MR) data together. The IR file has straightforward DHS variable names, however; the MR files has an 'm' added in the beginning of each variables.
I have used the below Stata code.
*mens recode
use "KEMR8BFL", replace
rename (mv001 mv002 mv003 mv005) (v001 v002 v003 v005)
sort v001 v002 v003
save "MRtemp.dta", replace
*individual recode
use "KEIR8BFL", clear
sort v001 v002 v003
merge v001 v002 v003 using "MRtemp.dta"
However, this code doesn't combine the data appropriately. What would be best approach to keep same variable names for both men and women by creating a sex variable and use survey weights appropriately?
The goal is to analyze the chronic disease indicators (chapter 14) primarily by gender and other characteristics. Although I have successfully replicated the Chapter 14 tables separately by sex, I am facing difficulty in consolidating them into one data file so that I can achieve my analysis goal.
I would greatly appreciate your insights and recommendations on the most efficient approach to address this issue.
Thank you for your time and assistance.
Best regards,
Thank you!
Muhammad
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
