A third option is to use a custom format. Example
proc format ;
value myvalue
low-high=[best8.]
other=' '
;
run;
Using the above format would display all non-missing values using the best8. SAS format, any other format could be used inside the [ ] and other values as a blank. This approach has the advantage of allowing you to display more characters without changing any variable lengths that a character value would but will appear in the output. Changing the format to, or creating a different format that is similar, to:
proc format ;
value myvalue
low-high=[best8.]
other='Not Recorded'
;
run;
would display "Not Recorded" or perhaps other more meaningful text in output for the missing values.
... View more
