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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.