The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Adding father's information to child information
Adding father's information to child information [message #20062] Tue, 22 September 2020 14:12 Go to next message
aswarola8 is currently offline  aswarola8
Messages: 1
Registered: September 2020
I want add some variables about the father e.g education, height, weight to each child's data in Stata. Is it better to merge the BR recode with the Men's recode or BR to Household? I am working in Stata. Thanks.

[Updated on: Wed, 23 September 2020 07:57] by Moderator

Report message to a moderator

Re: Adding father's information to child information [message #20075 is a reply to message #20062] Wed, 23 September 2020 08:55 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2866
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

You can only do this kind of match if both the child and the child's father are in the household. If they are, the the line number of the father is given by hv114 on the child's record (if the child is age 0-17) in the household. hv001 hv002 hv114 for the child will match with hv001 hv002 hvidx for the father in the PR file and mv001 mv002 mv003 in the MR file. The child with hv001 hv002 hvidx in the PR file will match with hv001 hv002 b16 in the KR or BR file. This is a relatively complicated merge but it can be done.

Whether you merge the child with the father using the PR file for the father or the MR file for the father depends entirely on whether the variables you want are in the PR file or the MR file. You may have more flexibility if you use the MR file, because (usually) everything about the father that is in the PR file will also be in the MR file.
Previous Topic: prevalence of anemia and associated factors in children (MIS Uganda 2018-2019)
Next Topic: Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS
Goto Forum:

Current Time: Thu Sep 28 14:24:48 Coordinated Universal Time 2023