SPSS guide
Why can’t I see my variable in an SPSS dialog box?
Short answer
Most SPSS dialogs only list variables of the right type. If your variable is a String (text), it won’t appear in boxes that need numbers, such as a t-test’s Test Variable list. Convert it to numeric with Transform › Automatic Recode, or change its Type in Variable View if it only holds numbers.
The common causes
- The variable is a String because it contains text, often after importing from Excel.
- In Chart Builder, the Measure setting decides where a variable can go: set it to Nominal, Ordinal or Scale in Variable View.
- The list shows labels rather than names. Right-click the list and choose Display Variable Names.
- The variable is in a different dataset window: check you’re in the right file.
How to fix a String variable
If it holds words (Male, Female), use Transform › Automatic Recode to create a numeric version with value labels. If it holds numbers stored as text, change its Type to Numeric in Variable View. Check a few cases afterwards: text such as “21 yrs” becomes missing.
Step-by-step tutorials
Still not sure which test fits?
Answer a few questions and the free tool tells you the test, the SPSS menu path and an APA example.