topic Re: proc report question; want to show data as zeros in SAS Procedures

proc report question; want to show data as zeros

Jeff293 — Thu, 29 Apr 2010 19:48:11 GMT

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;

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

Cynthia_sas — Thu, 29 Apr 2010 21:12:59 GMT

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

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

DataShare — Fri, 30 Apr 2010 09:44:26 GMT

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;