Call define in proc report

[Ajayvit]

Hi Guys,

here i am using prdsale data set. I am trying to color the quarter column on basis of their number. Ex 1=pink 2=yellow 3=green 4=red.

below is my code but it is not working.

proc report data=sashelp.prdsale;
column product quarter;
/*define quarter/ group;*/
COMPUTE quarter;
IF quarter >3
THEN CALL DEFINE(_col_, "style", "STYLE=[BACKGROUND=RED]");
ENDCOMP;
run;

[Ksharp]

By default, numeric variable is ANALYSIS usage, therefore refer to it by xxx.sum .

proc report data=sashelp.prdsale nowd;
column product quarter ;
/*define quarter/ group;*/
COMPUTE quarter;
IF quarter.sum >3
THEN CALL DEFINE(_col_, "style", "STYLE=[BACKGROUND=RED]");
ENDCOMP;
run;

[Ajayvit]

Thanks Ksharp

[Cynthia_sas · Accepted solution]

Hi:

  You can also accomplish what you want to do with a format, no CALL DEFINE needed.

Cynthia

proc format;
  value qfmt 1='pink'
             2='yellow'
             3='green'
             4='red';
run;
  
proc report data=sashelp.prdsale;
column product quarter;
define quarter /
       style(column)={background=qfmt.};
run;

[Ajayvit]

Thanks Cynthia