SMISSING Subcommand (CTABLES command)

 /SMISSING {VARIABLE}
           {LISTWISE}

If more than one scale variable is included in a table, you can control whether cases that are missing on one variable are included in summaries for which they have valid values.

VARIABLE. Exclude cases variable by variable. A case is included in summaries for each scale variable for which the case has a valid value regardless of whether the case has missing values for other scale variables in the table.

LISTWISE. Exclude cases that are missing on any scale variable in the table. This process ensures that summaries for all scale variables in the table are based on the same set of cases.

Listwise deletion applies on a per-table basis. Thus, given the specification

/TABLE (AGE [MEAN,COUNT]>SEX) + (AGE+CHILDS)[MEAN,COUNT] > HAPPY

all cases with valid values for AGE will be used in the AGE > SEX table, regardless of whether they have missing values for CHILDS (assuming that they also have valid values for SEX).