| Merging IR to PR [message #26245] |
Thu, 23 February 2023 13:05  |
azimkl10
Messages: 3
Registered: January 2023
|
Member |
|
|
Hi,
I managed to merge the 2018 IR file to the PR file by merging with these variables ha0, hv001, and hv002. However, I want each child (5-15) to have their mother's information. The information I want from the IR are v106, v130, v481, v501, v505 merged into the children's data. For example, v481 is whether respondent (mother) is covered by health insurance. I want whatever the mother's answer is to that question and apply it to all her children if that makes sense. I also wonder how I can tackle this situation if there are multiple women in the household?
Additionally, there are some variables in the PR file which are mother specific like ha66 which is woman's highest education level which I want to apply to all her children (instead of leaving it as NA in the data set) and I want to know how to go about that?
The reason for doing this is because I plan to analyze children 5-15 (while using some mother specific variables as covariants) and I want some of the mother's information to be kept and assigned to their children. I will filter through ages 5-15 to conduct analysis and I do not want to lose their mother's information when filtering.
Thank you for the help! I am open to solutions in Stata and R.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
