The DHS Program User Forum: Merging data files » SPSS - Merging Household variables with Individual Women's dataset

Home » Data » Merging data files » SPSS - Merging Household variables with Individual Women's dataset

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

Re: SPSS - Merging Household variables with Individual Women's dataset [message #2405 is a reply to message #2404]

Fri, 13 June 2014 09:14

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is an example code:

get file = 'ETIR61FL.SAV'.
STRING HHID (A12).
COMPUTE HHID = SUBSTR(CASEID,1,12).
VARIABLE LABELS HHID 'Household ID' .
EXECUTE .
MATCH FILES /FILE=*
/TABLE='ETHR61FL.SAV'
/BY hhid.
EXECUTE.
SAVE OUTFILE='HR_IR.SAV'
/COMPRESSED.

I hope this helps.

Bridgette-DHS

Report message to a moderator

[Message index]

		SPSS - Merging Household variables with Individual Women's dataset By: aligazan on Fri, 13 June 2014 05:02
		Re: SPSS - Merging Household variables with Individual Women's dataset By: Bridgette-DHS on Fri, 13 June 2014 09:14
		Re: SPSS - Merging Household variables with Individual Women's dataset By: aligazan on Fri, 20 June 2014 06:42
		Re: SPSS - Merging Household variables with Individual Women's dataset By: aligazan on Fri, 20 June 2014 06:47
		Re: SPSS - Merging Household variables with Individual Women's dataset By: Bridgette-DHS on Mon, 23 June 2014 13:43

Previous Topic:	Merge HIV and Couples
Next Topic:	mv001, mv002 and mv034_1 do not uniquely identify observations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jan 17 10:26:09 Coordinated Universal Time 2026