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