The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » SPSS - Merging Household variables with Individual Women's dataset
Re: SPSS - Merging Household variables with Individual Women's dataset [message #2405 is a reply to message #2404] Fri, 13 June 2014 09:14 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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

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


Current Time: Thu Mar 28 20:24:12 Coordinated Universal Time 2024