I am using PROC REPORT to simply print a few state names the a conditional format on the cell color based on the score value. I do not want to print the score value, just the state name. Additionally, I would like to add this output to a panel in PROC TEMPLATE, but see no options for the name to reference it. Is that even possible with this procedure?
proc report data=States nowd ;
columns state_name score;
define state_name/display center ;
define score / noprint;
compute state_name;
if score = 1 then do;
call define(_row_, "style", "style=[font_weight=bold background=BILG]");
end;
if score = 2 then do;
call define(_row_, "style", "style=[font_weight=bold background=gold]");
end;
if score = 3 then do;
call define(_row_, "style", "style=[font_weight=bold background=orange]");
end;
if score = 4 then do;
call define(_row_, "style", "style=[font_weight=bold background=VIYPK]");
end;
endcomp;
run;quit;
... View more
