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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.