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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.