Missing Values in Summaries (CTABLES command)

The following table presents the rules for including cases in a table for VALIDN, COUNT, and TOTALN functions when values are included or excluded explicitly through an explicit category list or implicitly through inclusion or exclusion of user-missing values.

Table 1. Inclusion/exclusion of values in summaries Variable and Value Type VALIDN COUNT TOTALN Categorical Variable: shown valid value Include Include Include Multiple Dichotomy Set: at least one “true” value Include Include Include Multiple Category Set: at least one shown valid value Include Include Include Scale Variable: valid value Include Include Include Categorical Variable: included user-missing value Exclude Include Include Multiple Category Set: all values are included user-missing Exclude Include Include Scale Variable: user-missing or system-missing Exclude Include Include Categorical Variable: excluded user-missing or system-missing value Exclude Exclude Include Multiple Dichotomy Set: all values are “false” Exclude Exclude Include Multiple Category Set: all values are excluded user-missing, system-missing, or excluded valid, but at least one value is not excluded valid Exclude Exclude Include Categorical Variable: excluded valid value Exclude Exclude Exclude Multiple Dichotomy Set: all values are excluded valid values Exclude Exclude Exclude