BookmarkSubscribeRSS Feed
gzr2mz39
Quartz | Level 8
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;
1 REPLY 1
Cynthia_sas
Diamond | Level 26
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Update

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1196 views
  • 0 likes
  • 2 in conversation