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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.