topic Re: Proc Report and missing values in SAS Procedures

Proc Report and missing values

PTD_SAS — Wed, 06 Mar 2013 22:56:54 GMT

I want to display missing numeric values as blanks in Proc Report, instead of the default dot. There is the option misstext= in Proc Tabulate but I couldn't find anything similar in Proc Report.

Would there be any way of achieving this?

Thanks.

Re: Proc Report and missing values

Cynthia_sas — Wed, 06 Mar 2013 23:50:55 GMT

Hi:

MISSTEXT is unique to PROC TABULATE. You have to specify:

options missing=' ';

and then after your procedure remember to switch it back to:

options missing=.;

cynthia

Re: Proc Report and missing values

PTD_SAS — Thu, 07 Mar 2013 00:10:36 GMT

Thanks Cynthia!