Proc Report Null Values as ' . '

[grodman]

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.

[Cynthia_sas]

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 */