Hi Esko,
1.Just let me know you want to highlight the complete column or the row with colors?
Or
2. You want to highlight based on the previous month comparison.
Yeah, you are correct there are few computation we can do in Proc Report. I think you can have a check with the below links for better understanding related to proc report.
https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/224-2008.pdf
title 'Some table' bold;
proc report data=example;
column month (push_ups pull_ups dips);
define month / group order=data 'Month';
define push_ups / display 'Push-ups';
define pull_ups / display 'Pull-ups';
define dips / display 'Dips';
/*if you want to apply color in complete row and pass the color code or name as per requirement*/
compute push_ups;
CALL DEFINE(_ROW_, "style", "STYLE=[BACKGROUD=HONEYDEW]");
endcomp;
/*if you want to apply color in complete column*/
compute pull_ups;
IF pull_ups > 10 then
CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUD=lightRED]");
endcomp;
COMPUTE dips;
CALL DEFINE("_c4_", "style","STYLE=[BACKGROUND=lightRED]");
endcomp;
run;
Somehow you can code like the above code, if you need the alteration in Rows, columns, Cell level or conditional level.
If any custom report you need which is by default not available with proc Report then I would suggest please prepare the data as per requirement may be with Data step or proc SQL Step, before using the dataset in proc report.
If you can share the output sample format with colors, may be from Excel you can do that then I can attempt to resolve your query completely.
Thanks and Gud luck.
... View more
