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;