topic Change Missing Value Character? in ODS and Base Reporting

Change Missing Value Character?

djbateman — Thu, 28 May 2015 17:11:29 GMT

Is it possible to change the character for a missing value? I am outputting a table of data with PROC REPORT, and my columns are numeric. When the report is generated and there is a missing value, it displays a ".", which I don't want. Is it possible to get SAS to display an empty cell without converting everything to character variables?

Re: Change Missing Value Character?

Astounding — Thu, 28 May 2015 17:42:57 GMT

Try this:

options missing=' ';

Then run PROC REPORT.

Re: Change Missing Value Character?

djbateman — Thu, 28 May 2015 17:46:17 GMT

I figured there would be a simple fix; I just wasn't sure where it was. Thanks!