topic Re: PROC Report - Apply same style in CALL DEFINE for multiple columns in SAS Programming

PROC Report - Apply same style in CALL DEFINE for multiple columns

elsfy — Wed, 11 May 2022 17:17:16 GMT

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

Re: PROC Report - Apply same style in CALL DEFINE for multiple columns

PaigeMiller — Wed, 11 May 2022 17:25:24 GMT

A small macro could work here.

Re: PROC Report - Apply same style in CALL DEFINE for multiple columns

Cynthia_sas — Wed, 11 May 2022 17:44:18 GMT

Hi:
If you are changing the entire ROW to be the same, then you can use _ROW_ (without quotes) as the first argument to CALL DEFINE. But the COMPUTE AFTER is changing the summary line. Will style(summary) do what you want in the PROC REPORT statement?
Cynthia

Re: PROC Report - Apply same style in CALL DEFINE for multiple columns

elsfy — Wed, 11 May 2022 20:59:41 GMT

Hi,

I don’t want to change the entire row. I have 10 columns and i just want this instruction for the first 3 columns.

Thank you

Re: PROC Report - Apply same style in CALL DEFINE for multiple columns

Cynthia_sas — Thu, 12 May 2022 13:28:33 GMT

Hi:
What you show is the only way to do it with 3 CALL DEFINE statements. Using macro code or a DO loop would also work, but would make the code more complex.
Cynthia