I don't know why there is a mismatch between qualtrics and spss, so unfortunately I can't help you with that.
However, I can help you with recoding your variables in spss.\
The best way to go there is to write a syntax that will do this for you. There are many advantages to using syntax, the most prominent being that if you discover a mistake somewhere, you can just go back to the syntax, adjust it and run everything again, without loosing time.
What you want to do is recode your variables, this can be achieved via the following syntax:
Code: Select all
Recode variable1 variable2 variable3 (4 = 1) (3 = 2) (7 = 3) (5 = 4) (2 = 5)
into Rvariable1 Rvariable2 Rvariable3.
where it says variable1 variable2 variable3 you type the variable names of every variable that follows this pattern (i.e., 4 = 1 etc).
where it says Rvariable1 etc, you typt a new variable name that indicates how your recoded variables should be named, it can be anything you want.
Now spss creates new variables which are the recoded versions of the old ones.
Please note that you should recode every value. For instance, if 3 is correct (it should remain 3 in the new variable) you should also indicate that by (3 = 3) and not leave it out.