I am preparing for analyses of the determinants of partner choice in SPSS, but basically I can't get off the ground because I don't know how to create new variables based on the information of each respondent's spouse (i.e. education, wages, social background, ethnicity etc.).
Each respondent is currently identified by an ID#, and exist two places in the matrix: as unit/respondent and as a spouse (either wife or husband), instantiated in a different column. What I need is开发者_如何转开发 to use info from each row of variables pertaining to an individual as respondent - to create new variables in the row of each person's spouse.
If it helps, I also have a separate file with all couples linked row-wise, as variables of the same unit - evidently with the same ID# as in my "variables-file" (yesterday, however, I merged these files - hopefully correctly...).
Assume you have a variables called age
, weight
, id
and spouse_id
in a file called main.sav
- Make a copy of
main.sav
and call itspouse.sav
- Relabel all the content variables in
spouse.sav
: i.e., makeage
spouse_age
andweigh
spouse_weight
- Remove the variable
id
fromspouse.sav
- Open
main.sav
and merge inspouse.sav
on the common IDspouse_id
. I.e.,data - merge files - add variables
精彩评论