The DHS Program User Forum: Merging data files » Duplicates in IR file when merging

Home » Data » Merging data files » Duplicates in IR file when merging

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

Duplicates in IR file when merging [message #8652]

Tue, 24 November 2015 20:25

nholla
Messages: 13
Registered: May 2015

Member

Hi DHS,

I'm trying to merge the individual to the birth recode files for several countries using the following code in stata, where the birth recode is the "master" file:

merge m:1 v001 v002 v003 using "filename", gen(ir)

However, I'm getting a "does not uniquely identify observations in the using dataset" error. I observed duplicates in terms of v001 v002 v003 for the following files:

Mali 2001
Niger 2000
Niger 1992
Senegal 1998
Senegal 1986
Nigeria 1990

Can multiple women have the same "respondent" in the IR file? If so, how could this occur? For a few of them, I was able to find an additional identifier (such as sconces or snumber). For those surveys I can't find an additional identifier, should I be merging on caseid?

Thanks!

Report message to a moderator

[Message index]

		Duplicates in IR file when merging By: nholla on Tue, 24 November 2015 20:25
		Re: Duplicates in IR file when merging By: Bridgette-DHS on Wed, 02 December 2015 08:14
		Re: Duplicates in IR file when merging By: nholla on Thu, 17 December 2015 11:19
		Re: Duplicates in IR file when merging By: Bridgette-DHS on Wed, 13 January 2016 08:18

Previous Topic:	Child Unique Identifier
Next Topic:	Malaria Indicator Survey: Malaria outcomes and women's characteristics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 23 15:19:49 Coordinated Universal Time 2024