topic Proc Report Null Values as ' . ' in SAS Programming

Proc Report Null Values as ' . '

grodman — Tue, 04 Feb 2014 01:42:02 GMT

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.

Re: Proc Report Null Values as ' . '

Cynthia_sas — Tue, 04 Feb 2014 02:36:51 GMT

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