The SAS Output Delivery System and reporting techniques

proc report column total excluding specific rows

Reply
Regular Contributor
Posts: 196

proc report column total excluding specific rows

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

Re: proc report column total excluding specific rows

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
Ask a Question
Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation