The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merge PR and KR in wave 3, b16 does not exist
Re: Merge PR and KR in wave 3, b16 does not exist [message #15379 is a reply to message #14951] Sun, 08 July 2018 23:16 Go to previous messageGo to previous message
kingx025 is currently offline  kingx025
Messages: 95
Registered: August 2016
Location: Minneapolis. Minnesota
Senior Member
I'm not sure what data you need to secure by merging the PR and KR observations. If you need some background characteristics about the households, such as type of toilet facility, source of drinking water, etc. as well as the child data, an alternative approach may be to go to IPUMS-DHS (, choose children as your unit of analysis (data from the KR file), and select additional variables relating to the mother's or household characteristics. We have merged the household file (HR) to the mother's (IR) files, and merged both to children's records (and birth records). Thus, if you create a customized dataset using IPUMS-DHS and children as the unit of analysis, you can add any characteristics related to the child's mother (including some not included in the original KR files, such as experience of domestic violence) and summary variables about the mother's household, such as type of toilet facility, source of water, wealth index, housing characteristics, agricultural and non-agricultural possessions, anti-malarial measures, nutritional indicators (such as iodized salt), and summary geography indicators.

The linking problems referred to in other messages in this thread did not affect our linking households to women (HR to IR) and linking women/mothers to children (IR to KR), so the approach described above may be a more general as well as a less labor-intensive solution.

Miriam King

Dr. Miriam King
IPUMS-DHS Project Manager (
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Mismatch between reported and generated output on merged file
Next Topic: Couple file from male and female dataset
Goto Forum:

Current Time: Sat May 30 01:27:03 Eastern Daylight Time 2020