data temp; do player1='a','b','c'; do player2='a','b','c'; do player3='a','b','c'; output; end; end; end; run; Hi.   Does this do what you are asking for? ... View more

Hello   Hope this isn't too late.   Try adding the following formats: VALUE $CHANNELleftborder 'chn1'='red' 'chn2' = ' ' ; VALUE $CHANNELrightborder 'chn1'=' ' 'chn2' = 'red' ; VALUE $CHANNELleftwidth 'chn1'='1' 'chn2' = '0.1' ; VALUE $CHANNELrightwidth 'chn1'='0.1' 'chn2' = '1' ;   and then the following code in the proc report:   CLASSLEV LEVEL/STYLE=[BACKGROUND=LILG JUST=C VJUST=C FONTSIZE=3.7 FONT_FACE='Arial' TAGATTR="WRAP:NO" bordertopcolor=red borderleftcolor=red borderrightcolor=red bordertopwidth=1 borderrightwidth=1 borderleftwidth=1 borderbottomwidth=0.1]; CLASSLEV CHANNEL/STYLE=[JUST=C VJUST=C FONTSIZE=3.5 FONT_FACE='Arial' BACKGROUND=$CHANNELcolor. borderleftcolor=$CHANNELleftborder. borderrightcolor=$CHANNELrightborder. borderleftwidth=$CHANNELleftwidth. borderrightwidth=$CHANNELrightwidth. TAGATTR="WRAP:NO"]; This should give what you want in excel.  It may not look right on the screen though.     Note that in ODS EXCEL borderwidths or 0-0.29 gives thin borders, 0.3 to 0.49 gives medium borders and 0.5-high gives thick borders.   Hope it helps.   Note that getting the bottom border for that whole area, or for a table in general is tricky but hopefully the borders this provides will help.   ... View more

Hi Paddy   To clarify: your variable is called frq_-1??    You should be able to use it in a column statement by specifying   'frq_-1'n  as the reference to that variable in the column statement.   If that's not what you were asking, let me know.           ... View more

Hi.   In SAS/STAT® 13.1 User’s Guide The BOXPLOT Procedure it suggests that annotate won't work if ODS graphics is enabled.   I just tried adding ODS graphics off;   before your code, and the annotate seemed to work.  (and the plot was horizontal).   Hope that helps.   ... View more