Hi,
I would like to know if there is a more efficient way of doing this :
proc report data = a ;
columns var1 var2 var3 var4 ....;
define var1 / display ;
define var2 / display ;
define var3 /display ;
... ;
rbreak after / summarize ;
... ;
compute after ;
call define ('var1','style','style={bordertopcolor=lightgrey borderbottomcolor=lightgrey}') ;
call define ('var2','style','style={bordertopcolor=lightgrey borderbottomcolor=lightgrey}') ;
call define ('var2','style','style={bordertopcolor=lightgrey borderbottomcolor=lightgrey}') ;
run ;
Instead of writing 3x "call define ...." for each variable, i would like to know if i can do it only one time but for the 3 variables/columns. (Just these 3, i have many other columns)
Thanks
A small macro could work here.
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.