I am looking for a way to create a composite variable from other variables in SPSS rather then in Excel.
Let's say I have three variables: Visiting the web (yes or no), Subscribed (yes or no) and Satisfied (Very, somewhat, not satisfied). I would like to create a variable that combines several combinations of these variables, allowing me to assign all my respondents to different value of my new variable. For instance :
New variable values :
1 - (visiting the web=yes + Subscribed=no + satisfied=very)
2 - (visiting the web=no + Subscribed=no + satisfied=very)
3 - (visiting the web=no + Subscribed=yes + satisfied=very)
and so on.
In excel, I would use the IF function. But it doesn't seem to work with the compute variable function in SPSS.
Does someone know to make it work?
Thank you in advance,