Hello! My data set looks like this: data example;
input month $3. push_ups pull_ups dips;
cards;
JAN 10 10 10
FEB 12 15 10
MAR 14 17 8
APR 16 19 11
MAY 20 18 11
JUN 21 17 11
;
run;
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';
run; I.e. after each month I measure how many repetitions of each kind of exercise I can do and add results to the table. I want to do more repetitions every month for each exercise, but sometimes I fail. I'd want to highlight the column with green/snow/red depending on result of comparison of my result in last month and previous one. For example, in this data set I'd like to highlight first column with green, second - with red and third - with snow (not to highlight it at all). I guess I can do it using COMPUTE statement, but I know only _RAW_ and _COL_, not _CELL_ parameters (I know also _VAL_, but I can't use it correctly in this situation and compare desired values). Maybe proc report not a right thing to use here, if so, I can use something else instead of it. My version of SAS is 9.4. Can someone help me or give a hint how to overcome this problem? Thanks in advance!
... View more
