/* Here is my updated code. You can now put anything as the format label. Please see the following link for explanation https://blogs.sas.com/content/sgf/2016/12/16/creating-and-using-multilabel-formats/ */
proc format;
value $ffmt (multilabel notsorted)
'a'='a'
'b'='b'
'a','b'='Sub Total ab'
'c'='c'
'a','b','c'='Total abc';
run;
proc tabulate DATA=rawdata FORMAT=comma12. ;
class Team / mlf preloadfmt order=data;
format Team $ffmt.;
VAR SUM_Y ;
table team, SUM_Y="Total Y"*Sum="" /box='Team';
run;
... View more
