The DHS Program User Forum
Discussions regarding The DHS Program data and results
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 Go to next message
Mukesh is currently offline  Mukesh
Messages: 9
Registered: March 2019
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?

    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


[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 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2742
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.
Previous Topic: IR and MR variables
Goto Forum:

Current Time: Mon Mar 27 19:24:49 Coordinated Universal Time 2023