Home » Data » Merging data files » Merging KR to MR OR (KR, IR, MR) (I want to have child variable and parent (mother-father) characteristics in one file.)
| Merging KR to MR OR (KR, IR, MR) [message #26418] |
Sat, 18 March 2023 10:53  |
Mukesh
Messages: 13
Registered: March 2019
|
Member |
|
|
I am working on NFHS-4 (2015-16)
I want to have the following variables in one file
child health variables, sex, birth order, child age, wealth index, religion, caste, maternal/paternal education, maternal/paternal age, BMI, anaemia
I wish to share existing views in user forum
1. KR file includes all relevant variables of the mother, so is it possible to merge KR directly to MR file that includes men's sample in which father are there?
OR
2. First, merge IR to CR for adding women's characteristics, then merge MR to CR for adding men's characteristics and Finally merge the KR with already merged CR ?
*my regression equation be like
child outcome = child_variables mother_variable father_var
Thanks!!
[Updated on: Sun, 19 March 2023 04:33] Report message to a moderator |
|
|
|
| Re: Merging KR to MR OR (KR, IR, MR) [message #26430 is a reply to message #26418] |
Mon, 20 March 2023 11:26  |
Bridgette-DHS
Messages: 3189
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
The only way to identify the biological father of a child is with hv113-hv114 in the PR file. You can identify a male household head (in the PR file) or the partner of the mother (in the CR file) but can't be sure that person is the father.
Recently we posted a program that will combine all information about the child, mother, and father on a single record. This works from the children in the PR file, not the children in the KR file, but will include nearly all the children in the KR file who are alive and living with the mother.
|
|
|
|
Goto Forum:
Current Time: Thu Nov 7 13:48:47 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
