Yes, but now my variables are character and I can’t make format for change the background colors based on the values. My code is like this but for example for kpiid=2 I need to present “Number of Total and PCT”. proc format; VALUE myfmt 0 - 15 = red 16 - 80 = orange 80 - high = yellow ; run; proc report data=mydata; col kpiid kpi_4 kpi_3 kpi_2 kpi_1 kpi_0; define kpiid / display ; define kpi_0-kpi_4 / display ; compute kpi_0; if kpiid = 1 then do; call define ('kpi_0','style','style={background=myfmt.}'); call define ('kpi_1','style','style={background=myfmt.}'); call define ('kpi_2','style','style={background=myfmt.}'); call define ('kpi_3','style','style={background=myfmt.}'); call define ('kpi_4','style','style={background=myfmt.}'); end; endcomp; run;
... View more