Tables without Missing Values
This example uses the data file survey_sample.sav. See the topic Sample Files for more information.
By default, user-missing categories are not displayed in custom tables (and system-missing values are never displayed).
- From the menus, choose:
- In the table builder, drag and drop Variable with missing values (the only variable in the file) from the variable list into the Rows area of the canvas pane.
- Right-click the variable on the canvas pane and select Categories and Totals from the pop-up menu.
- Click (check) Total in the Categories and Totals dialog box, and then click Apply.
- Right-click Variable with missing values in the table preview on the canvas pane again and select Summary Statistics from the pop-up menu.
- In the Summary Statistics dialog box, select Column N % in the Statistics list and click the arrow to add it to the Display list.
- Click Apply to Selection.
You may notice a slight discrepancy between the categories displayed in the table preview on the canvas pane and the categories displayed in the Categories list (below the variable list on the left side of the table builder). The Categories list contains a category labeled Missing Values that isn't included in the table preview because missing value categories are excluded by default. Since "values" is plural in the label, this indicates that the variable has two or more user-missing categories.
- Click OK to create the table.
Everything in this table is perfectly fine. The category values add up to the totals, and the percentages accurately reflect the values you'd get using the total count as the percentage base (for example, 3/7= 0.429, or 42.9%). The total count, however, is not the total number of cases in the data file; it's the total number of cases with non-missing values, or cases that don't have user-missing or system-missing values for that variable.