MISSING subcommand (CROSSTABS command)

By default, CROSSTABS deletes cases with missing values on a table-by-table basis. Cases with missing values for any variable specified for a table are not used in the table or in the calculation of statistics. Use MISSING to specify alternative missing-value treatments.

  • The only specification is a single keyword.
  • The number of missing cases is always displayed in the Case Processing Summary table.
  • If the missing values are not included in the range specified on VARIABLES, they are excluded from the table regardless of the keyword you specify on MISSING.

TABLE. Delete cases with missing values on a table-by-table basis. When multiple table lists are specified, missing values are handled separately for each list. This is the default.

INCLUDE. Include user-missing values.

REPORT. Report missing values in the tables. This option includes missing values in tables but not in the calculation of percentages or statistics. The missing status is indicated on the categorical label. REPORT is available only in integer mode.