70 likes | 189 Views
Identification of Individuals and Households, 1. HAZON92: Household ID for 1992. EAZON92: INDIVIDUAL ID for 1992. HAZON93: Household ID for 1993. EAZON93: INDIVIDUAL ID for 1993. CASE: Continuous Individual Case ID: 1-8237. + 1 digit BREAK-UP CODE.
E N D
Identification of Individuals and Households, 1 HAZON92: Household ID for 1992 EAZON92: INDIVIDUAL ID for 1992 HAZON93: Household ID for 1993 EAZON93: INDIVIDUAL ID for 1993 CASE: Continuous Individual Case ID: 1-8237 + 1 digit BREAK-UP CODE
Identification of Individuals and Households, 2 HAZON92: Household ID for 1992 EAZON92: INDIVIDUAL ID for 1992 HAZON93: Household ID for 1993 EAZON93: INDIVIDUAL ID for 1993 CASE: Continuous Individual Case ID: 1-8237 Same as HHID + 2 digits for members
ExHTFOVI: Relationship to Household Head HH head Spouse of the Head Children of the Head HH head Spouse of the Head Children of the Head
Switching to Household Level By Selection of Heads HH head HH head Select if (ExHTFOVI=1)
Creating a New Household Level Variable By Aggreagating the Individual Level File individual.sav aggregate /outfile = ’[YOUR DIR]\aggregate.sav' /presorted /break = hazon92 /newvar = sum (oldvar).
Matching Aggreagated Household Level Variables to Individuals aggregate.sav individual.sav Match files file = ’individual.sav' /table = ’aggregate.sav' /by = hazon92. Execute.
NEWVAR was matched to every member Note: In the HHP database every household level variables were matched back to individual cases.