Recoding multiple choice variables

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Fri Jun 09, 2017 12:25 pm

Recoding multiple choice variables

Postby rDanielS » Fri Jun 09, 2017 12:44 pm

I have a multiple choice question with 8 possible answers. The data was gathered in Google Forms then imported in Excel and from Excel in SPSS.
I hit automatic recode in SPSS for this variable and SPSS assigned for each combination that if found in the answers a number. For example if the guy checked a,b,c then SPSS gave it a 1, if they checked a,b,c,d then SPSS give it a 2 etc. It gives a code for every combination that it found in the answers.
The thing is that I want SPSS to code them like this:
he checks a=>score 1
he checks a,b=> score 2
The higher the number of boxes he checks the higher the score I want SPSS to give me for that response. HOw can I code/recode this variable without breaking it into dichotomic
separate variables?
Can I use something like this:
IF a,b,c then 3
IF a,b,c,d then 4
If a or b or c or .... then 1.
Posts: 2750
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: Recoding multiple choice variables

Postby statman » Fri Jun 09, 2017 4:34 pm

Might have to use the simple Rcode after to assign specific labels. Check this and let us know

Also ....................
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statistical Services

Who is online

Users browsing this forum: No registered users and 2 guests