SYSMIS Specification (MATRIX-END MATRIX command)

SYSMIS specifies how system-missing values should be handled when you have specified ACCEPT on MISSING.

  • The SYSMIS specification is ignored unless ACCEPT is specified on MISSING.
  • If you specify ACCEPT on MISSING but omit the SYSMIS specification, and a system-missing value is encountered for a variable being read, an error message is displayed and the GET statement is not executed.

The following keywords are available on the SYSMIS specification. There is no default.

OMIT. Skip an entire observation when a variable with a system-missing value is encountered.

value. Recode all system-missing values encountered to the specified value for entry. The replacement value can be any numeric constant.

Example 

GET SCORES
  /VARIABLES = TEST1,TEST2,TEST3
  /NAMES = VARNAMES
  /MISSING = ACCEPT
  /SYSMIS = -1.0.
  • A matrix named SCORES is read from the active dataset.
  • The variables TEST1, TEST2, and TEST3 form the columns of the matrix, while the cases in the active dataset form the rows.
  • A vector named VARNAMES, whose three elements contain the variable names TEST1, TEST2, and TEST3, is created.
  • User-missing values defined in the active dataset are accepted into the matrix SCORES.
  • System-missing values in the active dataset are converted to the value −1 in the matrix SCORES.