Help using Base SAS procedures

proc report question; want to show data as zeros

Reply
Occasional Contributor
Posts: 10

proc report question; want to show data as zeros

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;
SAS Super FREQ
Posts: 8,866

Re: proc report question; want to show data as zeros

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
SAS Employee
Posts: 13

Re: proc report question; want to show data as zeros

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;
Ask a Question
Discussion stats
  • 2 replies
  • 131 views
  • 0 likes
  • 3 in conversation