The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Egypt » Identify each mother to her children in child record (KR) dataset
Identify each mother to her children in child record (KR) dataset [message #11147] Tue, 08 November 2016 15:42 Go to next message
Messages: 10
Registered: November 2016
Location: UK

I am new DHS user and still trying to analysis the data.

I want to run a regular regression analysis to look for the paternal education, occupation, wealth on the children malnutrition.
I got to know that the children record dataset contains data/information about the mother and their children. so from that file I can obtain data about education, occupation and some demographic data. So how can I identify children to each mother? in order to be able to run my regression?

Appreciate you reply and help

Re: Identify each mother to her children in child record (KR) dataset [message #11164 is a reply to message #11147] Fri, 11 November 2016 10:20 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3117
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Each case in the KR file is a child born in the past five years. Information about the mother is attached to the same record. To combine with information about the father, you have to do a merge with another file (the PR file or the MR file). If the father and child are not living in the same household, then the information is not in any file.

I hope other forum users can provide more help.

Re: Identify each mother to her children in child record (KR) dataset [message #14601 is a reply to message #11164] Sun, 22 April 2018 14:19 Go to previous message
kingx025 is currently offline  kingx025
Messages: 95
Registered: August 2016
Location: Minneapolis. Minnesota
Senior Member
The data in the KR file is collected by asking women completing the individual women's survey about her own children, usually born in the past 5 years. To create the KR file, that data collected from individual mothers is reorganized so that children are the unit of analysis and much of the data about the reporting mother is copied over to the child's record as well. Some of the information about the mother--for example, if she experienced domestic violence--does not get copied over to the KR files.

For the IPUMS-DHS version of the KR files, we linked the mother's record and her household record to the child record, so all variables related to the mother and her household are available if you choose children as the unit of analysis. There is also sometimes information reported by the mother about her husband or partner, who is probably the father of the child. For example, V715 reports the total years of schooling for the mother's husband/partner; V705 reports the mother's partner's occupation; and V190 reports the wealth quintile of the woman's household.
Here's the display of variables for the Egyptian samples for education, work, and wealth quintiles from IPUMS-DHS, for our version of the KR data: d_wealth work ed

What I list above is material you can work with from just the KR file, but merging with the MR or PR file will give you more complete information about the father's characteristics, if he lives with the child.

Miriam King

Dr. Miriam King
IPUMS-DHS Project Manager (
Previous Topic: Variable Definition
Next Topic: Creating panel - using weights
Goto Forum:

Current Time: Wed Jul 24 01:59:07 Coordinated Universal Time 2024