The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merging data files

Show: Today's Messages :: Show Polls :: Message Navigator

Merging data files [message #23240]

Thu, 05 August 2021 05:45

Joshua
Messages: 2
Registered: July 2021

Member

Hi

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.
Joshua

Report message to a moderator

Re: Merging data files [message #23242 is a reply to message #23240]

Thu, 05 August 2021 09:25

Mlue
Messages: 92
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?

Report message to a moderator

Previous Topic:	Respondents not at home during interview
Next Topic:	merge IR and KR: duplicate line number in IR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 30 13:33:07 Coordinated Universal Time 2024