SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
Konkordanz
Pyrite | Level 9

Hi,

 

I tried several options but it doesnt work for me. What I want: A hole row shall be bold, if one column has a specific value.

For example with the sashelp.cars-data: I want to have a bold row, if the Make-Value is "Kia".

Thank you for help!

 

 

proc tabulate data=sashelp.cars;
class make type;
var msrp;
table make,type*msrp;
run;
3 REPLIES 3
Ksharp
Super User

Use PROC REPORT instead.

 

proc report data=sashelp.cars nowd;
columns make msrp,type;
define make/group style=header;
define type/across;
define msrp/analysis sum  ' ';
compute make;
 if make='Kia' then do;
  call define(_row_,'style','style={fontweight=bold}');
  call define(_col_,'style','style=header');
 end;
endcomp;
run;

Ksharp_0-1667304907716.png

 

Konkordanz
Pyrite | Level 9

Right, with proc-report its doable. But is there also a solution for the proc-tabulate-step?

Ksharp
Super User

OK. It is not easy for PROC TABULATE.

But how about this one ?

 

proc format;
value $ fmt
'Kia'='bold'
other='light'
;
run;

proc tabulate data=sashelp.cars;
class make type;
classlev make/style={fontweight=$fmt.};
var msrp;
table make*{style=<parent>{background=white foreground=black}},type*msrp;
run;

Ksharp_0-1667389287466.png

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 713 views
  • 1 like
  • 2 in conversation