The DHS Program User Forum: Merging data files » Merging Children with Household

Home » Data » Merging data files » Merging Children with Household

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

Re: Merging Children with Household [message #9376 is a reply to message #9348]

Tue, 22 March 2016 09:48

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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

The following should work (I have shortened your filenames):

use PEPR6IFL.DTA, clear
rename hv001 v001
rename hv002 v002
rename hvidx b16
sort v001 v002 b16
save PEPR6IFLTEMP1.DTA, replace

use PEKR6IFL.DTA, clear
sort v001 v002 b16
merge 1:1 v001 v002 b16 using PEPR6IFLTEMP1.DTA

Report message to a moderator

[Message index]

		Merging Children with Household By: befulina on Wed, 16 March 2016 20:34
		Re: Merging Children with Household By: Bridgette-DHS on Tue, 22 March 2016 09:48
		Re: Merging Children with Household By: befulina on Tue, 22 March 2016 14:52
		Re: Merging Children with Household By: user-rhs on Sat, 26 March 2016 22:53
		Re: Merging Children with Household By: befulina on Sun, 27 March 2016 13:59
		Re: Merging Children with Household By: user-rhs on Sun, 27 March 2016 14:46
		Re: Merging Children with Household By: Bridgette-DHS on Mon, 28 March 2016 10:06
		Re: Merging Children with Household By: user-rhs on Mon, 28 March 2016 14:58
		Re: Merging Children with Household By: Bridgette-DHS on Wed, 30 March 2016 12:26
		Re: Merging Children with Household By: user-rhs on Thu, 31 March 2016 15:52
		Re: Merging Children with Household By: Bridgette-DHS on Fri, 29 April 2016 08:52

Previous Topic:	Merging Birth and Household Recodes
Next Topic:	Dropping cases with HIV05 missing in SPSS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Dec 5 12:01:58 Coordinated Universal Time 2025