Help using Base SAS procedures

Proc Report and missing values

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

Proc Report and missing values

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.


Accepted Solutions
Solution
‎03-06-2013 06:50 PM
SAS Super FREQ
Posts: 8,868

Re: Proc Report and missing values

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

View solution in original post


All Replies
Solution
‎03-06-2013 06:50 PM
SAS Super FREQ
Posts: 8,868

Re: Proc Report and missing values

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

Contributor
Posts: 71

Re: Proc Report and missing values

Posted in reply to Cynthia_sas

Thanks Cynthia!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1479 views
  • 0 likes
  • 2 in conversation