Home » Data » Merging data files » Merging Men, Women, Child dataset into Household level unit analysis
| Merging Men, Women, Child dataset into Household level unit analysis [message #9199] |
Mon, 22 February 2016 07:55  |
goomthatha
Messages: 1
Registered: February 2016
Location: Paris
|
Member |
|
|
Hi to All,
I am using NFHS India 3 dataset. I would like to merge men, women, and children level data (IR, MR, KR) as a household unit. The individual dataset have caseID as opposed to HHID. When i merge these data, i want to group them as households. Its like adding women, men and children questionnaire in household dataset. I used below sample merge syntax for SPSS, to merge IR and HR dataset. but i am not getting the desired objective. Is there any better way to achieve this objective? I want to integrate variables from IR, MR, KR in household level. Is it possible?
GET FILE='C:\DATAUSER\ZMAR51FL.SAV'.
SORT CASES BY
HIVCLUST (A) HIVNUMB (A) HIVLINE (A).
SAVE OUTFILE='C:\DATAUSER\HIV.sav'
/COMPRESSED.
GET FILE='C:\DATAUSER\ZMIR51FL.SAV'.
SORT CASES BY
V001 (A) V002 (A) V003 (A) .
SAVE OUTFILE='C:\DATAUSER\WOMEN.sav'
/RENAME(V001 V002 V003=
HIVCLUST HIVNUMB HIVLINE)
/COMPRESSED.
GET FILE='C:\DATAUSER\WOMEN.sav'.
MATCH FILES /FILE=*
/TABLE='C:\DATAUSER\HIV.sav'
/BY HIVCLUST HIVNUMB HIVLINE.
EXECUTE.
SAVE OUTFILE='C:\DATAUSER\ZMAR_IR.SAV'
/COMPRESSED.
|
|
|
|
Current Time: Sun Dec 22 05:29:04 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
