Hi all- I am looking to apply "traffic lighting" to a column-There are two parts to the coloring scheme- One is percentage-over 95% is blue, and under 95% is red-that part works- However there is another value,colorscheme, that if 0 then I want to grayed it out-This has nothing to due with the value of compliance but rather is set on whether enough audits were done. The Data looks like this: FAC compliance colorscheme A 97 1 B 90 1 C . 0 D 99 0 Some of the pertinet code follows below- Thank you again- Lawrence Proc format; Value sigb low-<0.94500='red' <=0.945000-high='blue'; Value sigc low-<0.94500='black' <=0.945000-high='white'; run; ods escapechar="\"; ods graphics on/height=2.75in width=7in; options nodate nonumber center leftmargin=1in rightmargin=1in topmargin=1in bottommargin=1in; ods pdf file='P:\c dif dash1.pdf' style=styles.MyStyle; ods pdf anchor="page1"; proc report data=measures headline headskip nowd spanrows style(report)={font_size=7pt cellpadding=.3pt cellspacing=.5pt } style(column) = {font = ("arial",7pt)};; columns facility ('ROOM CLEANING' COMPLIANCE COLORSCHEME); DEFINE FACILITY/' ' format=$code. order style={linkcolor=black background=lightgray color=blue borderrightwidth=0 borderleftwidth=0 borderbottomwidth=0 bordertopwidth=0 };; DEFINE COMPLIANCE/XXX' format=percent10. style={background=sigb. color=sigc.}; DEFINE colorscheme/ analysis noprint; compute facility; urlstring=compress("#"||facility); call define(_COL_,'url',urlstring) ; endcomp; compute compliance; if colorscheme.sum=0 then call define(_COL_,'style','style={background=gray color=black}'); else if FACILITY in ('ZTO','ZZC') then call define(_ROW_,'style','style={background=lightgray color=black}'); endcomp; run;
... View more
