Hi All,
I would like to underline the highest value on each row of a report, as in this simple example :
data test;
input grp across $ value @@;
datalines;
1 a 1.1 1 b 1.3 1 c 1.2
2 a 2.1 2 b 2.3 2 c 2.2
3 a 3.1 3 b 3.2 3 c 3.3
;
ods rtf file="&sasforum.\reports\abcTable.rtf" style=journal;
proc report data=test nowd;
column grp across,value;
define grp / group;
define across / "" across;
define value / "" mean;
run;
ods rtf close;
I would like a result like:
Thanks.
PG
Hi PGStats
One can use arrays in a compute block. You can also change the sequence of across and analysis vars to make the headers look nicer See sample code below:
Bruno
Hi PGStats
One can use arrays in a compute block. You can also change the sequence of across and analysis vars to make the headers look nicer See sample code below:
Bruno
Thanks a lot Bruno! You made my day! - PG
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.