Question

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...).

Answer 1

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 it spouse.sav
Relabel all the content variables in spouse.sav: i.e., make age spouse_age and weigh spouse_weight
Remove the variable id from spouse.sav
Open main.sav and merge in spouse.sav on the common ID spouse_id. I.e., data - merge files - add variables

友情链接