Hi Vince, I´m only using sorts, query builder and summary tables of enterprise guide i´ve still with the problem unsolved, i can identify the 2 smallest values of each sub-set of data (7 values) from the column, but i still cannot apply the colors to these values I want the output in html or pdf, the print in excel was only an example proc report data=WORK.'QUERY_FOR_PROFIT'n nowd; column DATE cv1 COMPANY 'Fondo 1'n, SUM='Fondo 1_SUM'n 'Fondo 2'n, SUM='Fondo 2_SUM'n 'Fondo 3'n, SUM='Fondo 3_SUM'n 'Fondo 4'n, SUM='Fondo 4_SUM'n 'Fondo 5'n, SUM='Fondo 5_SUM'n; define DATE / group format=DATE9. missing noprint order=internal; define cv1 / computed 'DATE' format=DATE9. missing; compute cv1; if DATE ne . then hold1=DATE; cv1=hold1; endcomp; define COMPANY / group 'COMPANY' format=$CHAR9. missing order=formatted; compute COMPANY; if COMPANY ne ' ' then hold2=COMPANY; if COMPANY eq ' ' then COMPANY=hold2; endcomp; define 'Fondo 1'n / analysis SUM 'Fondo 1' missing; define 'Fondo 2'n / analysis SUM 'Fondo 2' missing; define 'Fondo 3'n / analysis SUM 'Fondo 3' missing; define 'Fondo 4'n / analysis SUM 'Fondo 4' missing; define 'Fondo 5'n / analysis SUM 'Fondo 5' missing; run; quit;
... View more