Unit 7 · Prepare your data
How to recode and reverse-score items in SPSS
Reverse-score questionnaire items and group values with Recode into Different Variables in SPSS, step by step.
Quick answer: How do you recode and reverse-score items in SPSS?
- Click Transform › Recode into Different Variables.
- Move the item across, type a new name (such as anx3_r) and click Change.
- Click Old and New Values and add each pair (1 → 5, 2 → 4, 3 → 3, 4 → 2, 5 → 1).
- Click Continue, then OK.
Recoding and reverse-scoring
Recoding changes the values of a variable according to rules you set, such as reversing a negatively worded questionnaire item or grouping ages into bands. Reverse-scoring makes sure a high number means the same thing on every item before you add them up.
When to use it
- Questionnaires with reverse-worded items (“I rarely feel anxious” in an anxiety scale).
- Collapsing categories, such as combining small groups.
- Turning a Scale variable into bands, though this throws information away.
How it works
For a scale running from a minimum to a maximum, reversed score = (minimum + maximum) − score. On a 1–5 scale, 1 becomes 5 and 2 becomes 4. Recode into Different Variables creates a new variable and keeps the original, so mistakes are easy to fix.
Worked example
On a four-item anxiety scale, item 3 is “I feel calm”. After recoding into anx3_r, a 5 (strongly agree) becomes a 1, matching the meaning of the other items.
Key terms
- Reverse-worded item
- An item where agreeing means less of the trait.
- Recode into Different Variables
- Creates a new variable, keeping the original.
Common mistakes
- Recoding into the same variable and losing the original data.
- Forgetting a value (such as the midpoint), which then becomes missing.
- Reversing the same item twice.
How to do it in SPSS
The SPSS syntax
Prefer typing to clicking? Open File › New › Syntax, paste this in, select it and choose Run › Selection. Every dialog's Paste button writes the same kind of code.
RECODE anx3 (1=5) (2=4) (3=3) (4=2) (5=1) INTO anx3_r.
VARIABLE LABELS anx3_r 'Anxiety item 3 (reversed)'.
EXECUTE.Practice data
Download the file used in this lesson and run it yourself in SPSS: you should get the same results as the screens above.
- anxiety_items.savFour anxiety items, one reverse-worded, with some missing answers (N = 100)
Now practise it interactively →
Reading is only half of it. Tap through the real SPSS menus, read the output and pick the right write-up in 7 quick questions, with instant feedback on every answer.
Practice for this lesson is part of Pro, with every unit, unlimited hearts and saved progress.