Hello, I want to ask you 2 questions about the same topic: 1. Some explanation. Avg_s1 & Avg_s4 is simple average.Avg_n_s1 is average + number of observation in parenthesis, this is a character variable, for example, 3.5(24). I want to color this variable based on numeric variables Avg_s1 & Avg_s4. And i don't want to display in the report Avg_s1 & Avg_s4. In the following code, when i change display to noprint option for Avg_s1 & Avg_s4 i don't get any color. proc sort data=report1_stat; by stn; run;
proc report data=report1_stat;
column stn AVG_S4=AVG_S4_ALIAS AVG_S1 AVG_S4 avg_n_s1;
define stn / order;
define AVG_S4_ALIAS / noprint;
define AVG_S1 / display; define AVG_S4 / display;
define avg_n_s1 / display &smpl1_label;
compute avg_n_s1;
if (AVG_S1/AVG_S4_ALIAS-1)>0.2 and AVG_S4_ALIAS~=. then do;
call define('avg_n_s1', "style", "style=[background=lightred]");
end;
if (AVG_S4_ALIAS/AVG_S1-1)>0.2 and AVG_S4_ALIAS~=. then do;
call define('avg_n_s1', "style", "style=[background=lightgreen]");
end;
endcomp;
run; 2. Suppose i have the following data, that consist of last 12 monthes and avertage for whole year, of course the months change dynamically during period. My question is how can i color months average values by condition, for example, if average month is higher by 20% from whole year average. Because i don't know exactly variable names. type AVG MAR22 FEB22 JAN22 DEC21 NOV21 OCT21 SEP21 AUG21 JUL21 JUN21 MAY21 APR21 A 9.49 5.47 9.25 9.85 9.12 6.36 10 17 9.83 7.35 6.44 11.17 8.56 THANK YOU!!!
... View more