proc report question; want to show data as zeros

[Jeff293]

The following PROC REPORT work fine for me except that a few rows for RECORDS have no data so a period is displayed. I'd like to show these as zeros instead. Can this be done in a format statement or other coding in PROC REPORT? thanks. Jeff

proc report out=friday2 headline headskip missing nofs;
Title1 'School Division claims';
column provider year, records;
define provider / group;
define year / across ;
define records / analysis sum;
rbreak after / dol summarize ;
run;

[Cynthia_sas]

Hi:
Investigate the MISSING= system option.

options missing=0;
or
options missing=' ';

The options statement would go before your PROC REPORT step and serves the purpose of telling SAS how missing values should be displayed. In the first statement, missing values would be displayed as 0, in the second statement, missing values would be displayed as a single space.

cynthia

[DataShare]

in case u want to change the period to zero in the dataset itself
data In;
c1=1;
output;
c1=. ;
output;
run;
data Out ;
set In;
c1=coalesce(c1, 0);
run;