The SAS Output Delivery System and reporting techniques

Replacing Missing values in Proc report

Reply
Super Contributor
Posts: 268

Replacing Missing values in Proc report

Hello,
Isnt there a way to replace missing values in a Proc Report with a blank or a special character?

I went through the options listed in SAS Documentation but nothing seems to appeal to me.

Thanks,
saspert.
Occasional Contributor
Posts: 11

Re: Replacing Missing values in Proc report

options missing=' ';

Add this code before the proc report statement.
Super Contributor
Posts: 268

Re: Replacing Missing values in Proc report

Great! Thank you.
New Contributor
Posts: 3

Re: Replacing Missing values in Proc report

Just to add here. It doesn't need to be prior to proc report. 'Options missing=' statement will also work within the proc report statement. 

Post a Question
Discussion Stats
  • 3 replies
  • 2730 views
  • 1 like
  • 3 in conversation