When we start analyzing a data file, we first inspect our data for a number of common problems. For instance, we want to be sure that variables have the right formats, don't contain any weird values and have plausible distributions. The table below proposes which steps should be taken and in which order.
For getting the most out of these tutorials, we encourage you to follow along by downloading and opening hotel_evaluation.sav.

SPSS Data Preparation - Overview Main Steps
Check for | How? | Fix | |
---|---|---|---|
1 | Case count and variable count | Inspect data view | (Not applicable) |
2 | Unique Case Identifier | Use AGGREGATE command | Create unique ID variable |
3 | Undesirable Variable Types | Inspect variable view and data view | Convert Variables |
4 | Presence of user missing values | Frequency table or histogram per variable | Specify user missing values |
5 | Variables with many missing values | Bar chart or histogram per variable | Drop variables or exclude from analyses |
6 | Inconvenient distributions | Bar chart or histogram per variable | Drop variables or exclude from analyses |
7 | Small categories | Bar chart per variable | Merge categories |
8 | Undesirable coding | Bar chart per variable | Reverse code variable(s) |
9 | Cases having many missings | Compute number of missing values per case | Exclude Cases from Analysis |
SPSS Data Preparation - Workflow
So how do we perform these checks in practice? We propose you first perform steps 1-3 since they involve the entire data file.
Next, we inspect each variable in our data -from top to bottom- separately. If the variable is categorical, we create a frequency table with a bar chart. If the variable is metric, we run a histogram. Based on this output, we perform steps 4-8.
All output for these steps is created with simple FREQUENCIES commands, which can take multiple variables at once. You may consider running these for groups of (similarly coded) variables rather than variables separately.
After inspecting -and possibly correcting- each variable, we round up with step 9.
THIS TUTORIAL HAS 9 COMMENTS:
By COLLINCE OMONDI OTIENO on June 3rd, 2016
This site is quite important for basic data inspection, one should get a simpler way to download this demonstrative templates for easy views and learning.
By wael on June 28th, 2016
can you help me for SPSS Data Preparation
By Ruben Geert van den Berg on June 28th, 2016
Sure, feel free to send me an email with the details regarding your request. Please keep in mind that we do charge for consulting.
By aholu buduziri christian on August 18th, 2016
how much is the cost of data analysis with 6 hypotheses
By Ayan Hassan Mohamed on April 5th, 2017
Thanks for your introduction, i need basic until advanced SPSS