Merging individual and household data in SPSS
I am trying to look at disability onset and offset rates (so if people become or lose their impairments/disability over time) by different demographics, one of these being income/poverty.
For each of the waves I have been able to create a household poverty figure. However I need to know if anyone who is disabled is in these households and measure this over time. This involved merging the individual and household data longitudinally.
I have seen the user manual for guidance on how to do this in STATA, but need to find out how to do this SPSS.
I have tried using each waves household identifier to merge the data and then the individual identifier to merge across waves. But when merging the individual data (the disability variable - showing whether respondent is disabled or not) and household data the poverty measure aligns with the first respondent in each household. Which is fine if looking at individual waves, however, when merging the waves, as the same household respondent doesn't always answer the questionnaire, the poverty variables do not align (e.g. below) - so I cannot conduct any analysis on this.
e.g. - column 1 household identifier, column 2 household respondent no, column 3 disabled and in poverty wave1, column 4 disabled and in poverty wave2:
Is there a simple solution to this - and is it possible to do in SPSS?