topic Re: Replacing Missing values in Proc report in ODS and Base Reporting

Replacing Missing values in Proc report

saspert — Tue, 08 Mar 2011 16:56:40 GMT

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.

Re: Replacing Missing values in Proc report

AndyJ — Tue, 08 Mar 2011 17:19:31 GMT

options missing=' ';

Add this code before the proc report statement.

Re: Replacing Missing values in Proc report

saspert — Tue, 08 Mar 2011 21:53:50 GMT

Great! Thank you.

Re: Replacing Missing values in Proc report

vasifvora0 — Tue, 09 Aug 2016 19:52:58 GMT

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.