topic Re: proc report: How to color the row I created w the compute & line statement? in SAS Procedures

proc report: How to color the row I created w the compute & line statement?

Eva — Mon, 22 Nov 2010 14:35:09 GMT

Hi!

in a proc report I create a new row with compute and the line statement. Now I's like to set the background color of this row. However, the call define shows no effect. Here's my code:

proc report mydata;
column mycol1 mycol2;
define mycol1 / group '';
define mycol2 / analysis sum '';

compute after mycol1;
@1 line 'my group heading';
call define(_row_,'style','style={font_weight=bold backgroud=blue}');
endcomp;
run;

Best regards
Eva

Re: proc report: How to color the row I created w the compute & line statement?

Cynthia_sas — Mon, 22 Nov 2010 15:46:43 GMT

Hi:
Technically, the area created by a LINE statement is controlled by different methods than the _ROW_ method. So you have 2 ways to control the output from a LINE statement:
1) use STYLE(LINES) in a PROC REPORT statement to control the style of all the LINE statement output; or
2) add the style override to your COMPUTE statement which will ONLY impact the LINE output that is contained within that COMPUTE block:
[pre]
compute after mycol1 /
style={font_weight=bold backgroud=blue just=l};
line 'my group heading';
endcomp;
[/pre]

Note also that I removed the @1 in favor of using JUST=L. Generally speaking the use of @ pointer controls rarely results in the output you want. By using @1, I assume you wanted to left-justify your text string.

cynthia

Re: proc report: How to color the row I created w the compute & line statement?

Eva — Tue, 23 Nov 2010 10:01:04 GMT

Dear Cynthia,

thanx a lot fpr your great answer - as usual a great inspiration for accumulating knowledge 🙂

Best regards
Eva