Chapter Contents |
Previous |
Next |
Numeric Variables |
Within SAS, a missing value for a numeric variable is smaller than all numbers; if you sort your data set by a numeric variable, observations with missing values for that variable appear first in the sorted data set. For numeric variables, you can compare special missing values with numbers and with each other. Numeric Value Sort Order shows the sorting order of numeric values.
Sort Order | Symbol | Description | |
---|---|---|---|
smallest | ._ | underscore | |
. | period | ||
.A-.Z | special missing values A (smallest) through Z (largest) | ||
-n | negative numbers | ||
0 | zero | ||
largest | +n | positive numbers |
For example, the numeric missing value (.) is sorted before the special numeric missing value .A, and both are sorted before the special missing value .Z. SAS does not distinguish between lowercase and uppercase letters when sorting special numeric missing values.
Note: The numeric missing value
sort order is the same regardless of whether your system uses the ASCII or
EBCDIC collating sequence.
Character Variables |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.