Resolving the Subtle Problem - SAS Programming

To prevent the intermingling of missing and non-missing values,and the resulting incorrect designation of some non-missing values as missing,simply include a separate range for missing values as follows:

Example

«-
PROC FORMAT;
VALUE GOODFMT . = 'MISSING'
1 = 'ONE'
2 = 'TWO'
OTHER = 'MISCODED
.

The new format is able to distinguish between missing values and out-of-range values,and this solution provides you with acceptable output as shown in Output 3:

Output from Example - Resolving the Subtle Problem

Output from Example - Resolving the Subtle Problem

You are now accurately categorizing the missing value as missing, as is noted in the Frequency Missing = 1 note.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAS Programming Topics