Proc Report - coloring cell depending on value of other column

[sascom10]

Hello,
Basically I'm trying to color column cell using value of other column.
I would like to have all values of COL2 displayed colored where COL1='A'.
However, with following code only first value of COL2 where COL1='A' is being displayed colored.

Please suggest!!
Thanks!!

data test1;
  input COL1 $1. COL2 $5. NUM1;
datalines;
A rx1 2
A rx2 1
B rx1 1
B rx2 2
B rx2 5
B rx3 3
run;

ods pdf file="C:\test.pdf" notoc /*style=mystyle*/ uniform;

proc report data=test1 nofs nocenter headline headskip split="/" /*spanrows*/;
  column col1 col2 num1;

  define col1 / group;
  define col2 / group;
  define num1 / analysis sum;

  compute col2;   
if col1='A' then
  call define(_col_, "style", "STYLE=[BACKGROUND=cxFFFF82]");
  endcomp;
run;

ods pdf close;

[data_null__ · Accepted solution]

You need to "remember" the value of col1.

proc report data=test1 nofs nocenter headline headskip split="/" /*spanrows*/;
   column col1 col2 num1;
   define col1 / group;
   define col2 / group;
   define num1 / analysis sum;
   compute before col1;
      col1r=col1;
      endcomp;
   compute col2;   
      if col1r='A' then
         call define(_col_, "style", "STYLE=[BACKGROUND=cxFFFF82]");
      endcomp;
   run;

[sascom10]

Excellnt, this works!

Thanks!!