MISSING Subcommand (EXAMINE command)

MISSING controls the processing of missing values in the analysis. The default is LISTWISE, EXCLUDE, and NOREPORT.

  • LISTWISE and PAIRWISE are alternatives and apply to all variables. They are modified for dependent variables by INCLUDE/EXCLUDE and for factor variables by REPORT/NOREPORT.
  • INCLUDE and EXCLUDE are alternatives; they apply only to dependent variables.
  • REPORT and NOREPORT are alternatives; they determine if missing values for factor variables are treated as valid categories.

LISTWISE . Delete cases with missing values listwise. A case with missing values for any dependent variable or any factor in the model specification is excluded from statistics and plots unless modified by INCLUDE or REPORT. This is the default.

PAIRWISE. Delete cases with missing values pairwise. A case is deleted from the analysis only if it has a missing value for the dependent variable or factor being analyzed.

EXCLUDE. Exclude user-missing values. User-missing values and system-missing values for dependent variables are excluded. This is the default.

INCLUDE. Include user-missing values. Only system-missing values for dependent variables are excluded from the analysis.

NOREPORT. Exclude user- and system-missing values for factor variables. This is the default.

REPORT . Include user- and system-missing values for factor variables. User- and system-missing values for factors are treated as valid categories and are labeled as missing.

Example

EXAMINE VARIABLES=RAINFALL MEANTEMP BY REGION.
  • MISSING is not specified and the default is used. Any case with a user- or system-missing value for RAINFALL, MEANTEMP, or REGION is excluded from the analysis and display.

Example

EXAMINE VARIABLES=RAINFALL MEANTEMP BY REGION
  /MISSING=PAIRWISE.
  • Only cases with missing values for RAINFALL are excluded from the analysis of RAINFALL, and only cases with missing values for MEANTEMP are excluded from the analysis of MEANTEMP. Missing values for REGION are not used.

Example

EXAMINE VARIABLES=RAINFALL MEANTEMP BY REGION
  /MISSING=REPORT.
  • Missing values for REGION are considered valid categories and are labeled as missing.