O'Reilly logo

SAS 9.4 Language Reference, 6th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

run;
The following output is produced:
Output 5.1 Output with Multiple Missing Values
Order of Missing Values
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. The following table shows the
sorting order of numeric values.
Table 5.1 Numeric Value Sort Order
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
Order of Missing Values 85

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required