The DHS Program User Forum: Merging data files » Merging Individual and HH Member Recode Files

Home » Data » Merging data files » Merging Individual and HH Member Recode Files

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

Re: Merging Individual and HH Member Recode Files [message #13925 is a reply to message #10611]

Thu, 25 January 2018 12:55

rayhangog@gmail.com is currently offline

rayhangog@gmail.com
Messages: 4
Registered: January 2018
Location: New Delhi

Member

Dear,
I am trying to merge IR file with KR file, and PR file with KR+IR files from Peru's latest DHS data. But, in the first step, KR & IR does not match. I am following the below command in Stata;

*Merge child+women file
sort v001 v002 v003 merge
m:1 v001 v002 v003 final2 using "E:DataDHSPeruPEIR6IFL.DTA"

"variables v001 v002 v003 do not uniquely identify observations in the using data r(459);"

While the files from other countries have been merged with the same command. Please help me with this and provide me proper command

* Command for merging child+women and household member file (PR)
*rename in child file (KR+IR) . rename b16 mergeid . sort v001 v002 mergeid
*rename in household member file (PR)
rename hv001 v001
rename hv002 v002
rename hvidx mergeid
sort v001 v002 mergeid

Thank you

Report message to a moderator

[Message index]

		Merging Individual and HH Member Recode Files By: amw289 on Tue, 26 July 2016 15:37
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Wed, 27 July 2016 17:12
		Re: Merging Individual and HH Member Recode Files By: amw289 on Sun, 31 July 2016 12:02
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Mon, 01 August 2016 12:04
		Re: Merging Individual and HH Member Recode Files By: amw289 on Tue, 02 August 2016 12:05
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Thu, 11 August 2016 16:07
		Re: Merging Individual and HH Member Recode Files By: amw289 on Tue, 16 August 2016 10:02
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Tue, 16 August 2016 12:13
		Re: Merging Individual and HH Member Recode Files By: amw289 on Tue, 16 August 2016 12:36
		Re: Merging Individual and HH Member Recode Files By: rayhangog@gmail.com on Thu, 25 January 2018 12:55
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Sun, 28 January 2018 14:49
		Re: Merging Individual and HH Member Recode Files By: rayhangog@gmail.com on Sun, 28 January 2018 15:10

Previous Topic:	Merging Rwanda DHS 1992 without b16
Next Topic:	NFHS 4 Data (Merging of PR and KR data file)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 12:21:26 Coordinated Universal Time 2024