Proc Report, how to change the '.' or '' of missing values to 'Unknown'

[mcook]

In proc report, how do i get the '.'  value to be displayed as 'unknown', rather than the missing indicator (see table below).  For character variables i could simply change all missing values to 'unknown' in the dataset, but i cannot do that with numerical vars.  

[A_Kh]

Hi, 

Use PROC FORMAT before proc report, then apply created format in proc report to display  the missing value as 'unknown'.

[Patrick]

If you're already using a SAS supplied format like percent. below sample code to demonstrate how you can extend it for a missing case.

proc format;
  value missToUnknown
    . = 'Unknown'
    other=[percent.]
    ;
run;

data demo;
  do var=-0.5,.,0,0.5;
    output;
  end;
run;

proc print data=demo;
  format var missToUnknown.;
run;