proc report column total excluding specific rows

gzr2mz39 — Fri, 25 Feb 2011 17:47:44 GMT

Does anyone know how to modify this code in order to compute totals for each of the columns (ie RBREAK) while excluding specific rows?
For example, how would I exclude rows 2 and 4 (ie div in (2,4)) from the column totals?
Thank you.
proc report data=org nowd contents="Claims" out=test
style(header)=[font_weight=bold];
options missing='0';
column department div tot_osha tot_nlt tot_lt;
define department /group 'Customer Service' width=18 style(column)={just=l} order=data;
define div / group noprint;
define tot_osha / 'Total' style(column)={background=gold};
define tot_nlt / 'Non-Lost Time';
define tot_lt / 'Lost Time';
compute div;
if div in (1,7,8,9,10,11,12,13) then call define(_row_,"style","style=[font_weight=bold fontsize=3.5]");
endcomp;
run;

Re: proc report column total excluding specific rows

Cynthia_sas — Fri, 25 Feb 2011 20:11:26 GMT

This idea must be out in the universe -- look at some of the examples at the bottom of this thread -- particularly the most recent ones.
http://support.sas.com/forums/thread.jspa?threadID=13048&tstart=0

cynthia

topic proc report column total excluding specific rows in ODS and Base Reporting

proc report column total excluding specific rows

Re: proc report column total excluding specific rows