The SAS Output Delivery System and reporting techniques

Change Missing Value Character?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 237
Accepted Solution

Change Missing Value Character?

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?


Accepted Solutions
Solution
‎05-28-2015 01:42 PM
Super User
Posts: 5,516

Re: Change Missing Value Character?

Posted in reply to djbateman

Try this:

options missing=' ';

Then run PROC REPORT.

View solution in original post


All Replies
Solution
‎05-28-2015 01:42 PM
Super User
Posts: 5,516

Re: Change Missing Value Character?

Posted in reply to djbateman

Try this:

options missing=' ';

Then run PROC REPORT.

Regular Contributor
Posts: 237

Re: Change Missing Value Character?

Posted in reply to Astounding

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

🔒 This topic is solved and locked.

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

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