Proc Report Null Values as ' . '

Reply
Occasional Contributor
Posts: 19

Proc Report Null Values as ' . '

This is going to be a simple/dumb question... but when running proc report on a dataset where some observations have null values, the null values get displayed as '.' in the report output.  Is there a setting that will make null values simply show up as blank? ("")

Thanks in advance.

SAS Super FREQ
Posts: 8,743

Re: Proc Report Null Values as ' . '

Hi:

  Not unique to PROC REPORT, but you can read up on the the MISSING system option.

cynthia

options missing=' ';  /* displays . as space in reports */

ods xxx file='c:\temp\myreport.xxx';

...your code;

ods xxx close;

options missing = .;  /* returns option to default */

Ask a Question
Discussion stats
  • 1 reply
  • 197 views
  • 0 likes
  • 2 in conversation