|
⇤ ← Revision 1 as of 2023-06-13 01:16:23
Size: 1101
Comment:
|
← Revision 2 as of 2023-06-13 01:20:08 ⇥
Size: 1213
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 18: | Line 18: |
| missing values ham spam eggs ('NULL'). | missing values ham ('NULL') /spam eggs ('NULL', 'NA', ''). |
| Line 28: | Line 29: |
Trailing spaces are trimmed from string values when checking for a user missing value. |
SPSS Missing Values
The MISSING VALUES command sets user missing values for a variable.
Contents
Usage
missing values foo bar (9)
/baz (9, 0).
missing values foo bar (90 thru 99)
/baz (90 thru 99, 0).
missing values ham ('NULL')
/spam eggs ('NULL', 'NA', '').The forward slashes (/) are optional.
Specifying no values between the parentheses (()) is equivalent to deleting the user missing values setting for a variable.
Up to three user missing values may be specified. If a numeric range is specified, up to one other user missing value may be specified.
The keywords HI/HIGHEST and LO/LOWEST dynamically capture the highest and lowest value. They are valid only in a numeric range.
Trailing spaces are trimmed from string values when checking for a user missing value.
Data Model
The MISSING VALUES command executes immediately. Pending transformations are not executed and the active dataset is not read.
See also
PSPP manual for MISSING VALUES