# Thread: Seems so simple but I cannot figure it out -> combine 3 variables into one

1. ## Seems so simple but I cannot figure it out -> combine 3 variables into one

Please keep in mind I know little of stats and how to use SPSS. I would really appreciate some help.

for example: q1=do you like apples?, q2=do you like pears?, q3=do you like oranges?
Each is a yes/no question and 0=no 1=yes

I want to combine q1-q3 into a new variable so I can simply find out the percentage of people that say yes and and that say no to simply "liking fruit"

Is this possible? How can I do this using SPSS's menu options? Serious thanks to anyone that can help me.

2. ## Re: Seems so simple but I cannot figure it out -> combine 3 variables into one

If you don't want to use syntax, it's a three step process:

1. From the Transform menu, compute a new value. Add Q1 + Q2 + Q3. Give the new variable a name (eg LikeFruit).
2. From the Transform menu, recode the new variable (either same or different -- your choice). Set the values as 0=0, and 1 thru 3 as 1.
3. From the Variable View tab, assign value labels to the new variable. 0 = no and 1 = yes.

 Tweet