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

Re: Duplicates in IR file when merging [message #8914 is a reply to message #8784]

Wed, 13 January 2016 08:18

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

If you list out caseid and v003 for the first few cases in the IR file, and list out hhid for the first few cases in the HR file, you will see that caseid is simply a combination of hhid and v003.

Both caseid and hhid are character strings (str15 and str12, respectively); v003 is numeric.

Before you do the merge, when you open the IR file, use this line: gen hhid=substr(caseid,1,12). Then merge with the IR file using hhid. I think this will work for what you want to do, but let me know if it does not.

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: Tue Dec 24 12:48:19 Coordinated Universal Time 2024