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 #2464 is a reply to message #2458]

Mon, 23 June 2014 13:43

Bridgette-DHS
Messages: 3035
Registered: February 2013

Senior Member

Where are you getting the variables: "s12" and "s36" from (in your syntax)?

The syntax we posted seems perfectly fine, and all you have to do is modify the file names and the path for the file location. See modified syntax below:

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

[Updated on: Thu, 25 June 2015 13:38]

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: Fri Apr 19 01:30:28 Coordinated Universal Time 2024