The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging data files
Merging data files [message #23240] Thu, 05 August 2021 05:45 Go to next message
Joshua is currently offline  Joshua
Messages: 2
Registered: July 2021


I am currently analyzing DHS data using the birth records dataset. However, I would like to adopt certain variables from the Household datasets. The variable in the birth record dataset is more than that of the household dataset. So when I attempt to merge the two datasets I keep getting the message on STATA that "variable does not uniquely identify observations in the master data".

What would be the best way to merge birth records (n=50,000) and Household (n=20,000) datasets?

Thank you

Kind regards.
Re: Merging data files [message #23242 is a reply to message #23240] Thu, 05 August 2021 09:25 Go to previous message
Messages: 91
Registered: February 2017
Location: North West
Senior Member
Good day,

The information provided is incomplete. Which country and survey year are you referring to? Are you trying to merge the BR and HR files, or the BR and PR files?
Previous Topic: Respondents not at home during interview
Next Topic: merge IR and KR: duplicate line number in IR
Goto Forum:

Current Time: Thu Jun 30 22:17:20 Coordinated Universal Time 2022