Hi Cynthia,
Thx for your reply. It's tabular data, not a chart. I've provided the code below.
So, what I'm trying to do is have text run against the outside of the table, on the left side, running from bottom to top, 90 degree angle. I was thinking this might be possible using
"compute ?/? ;
line 'TEXT HERE'; "
But I can't get teh placement right.
Thx,
Scott
proc report data = work.error_ct;
columns
CS Scenario_Name Revenue_Impact &comm_mon_fri5 &comm_mon_fri4 &comm_mon_fri3 &comm_mon_fri2 &comm_mon_fri
Monthly_Impact;
title1 Weekly Commercial Monitoring Report - &comm_mon_fri;
define CS / display center;
define Scenario_Name / display 'Scenario Name';
define Revenue_Impact / display center 'Revenue Impact';
define &comm_mon_fri5 / display center format = comma10.;
define &comm_mon_fri4 / computed;
define &comm_mon_fri4 / display center format = comma10.;
define &comm_mon_fri3 / computed;
define &comm_mon_fri3 / display center format = comma10.;
define &comm_mon_fri2 / computed;
define &comm_mon_fri2 / display center format = comma10.;
define &comm_mon_fri / computed;
define &comm_mon_fri / display center format = comma10.;
define Monthly_Impact / display 'Monthly Impact' center;
footnote j=l 'A green background = Error set decreased by 10%';
footnote2 j=l 'A red background = Error set increased by 10%';
footnote3 j=l 'LEGEND';
compute &comm_mon_fri4;
if (((&comm_mon_fri5-&comm_mon_fri4)/&comm_mon_fri5)*100) < -10
and &comm_mon_fri5 <> 0
then
call define(_col_,"style", "style=[background=red]");
else if(((&comm_mon_fri5-&comm_mon_fri4)/&comm_mon_fri5)*100) > 10
and &comm_mon_fri5 <> 0
then
call define(_col_,"style",
"style=[background=green]");
endcomp;
compute &comm_mon_fri3;
if (((&comm_mon_fri4-&comm_mon_fri3)/&comm_mon_fri4)*100) < -10
and &comm_mon_fri4 <> 0
then
call define(_col_,"style", "style=[background=red]");
else if (((&comm_mon_fri4-&comm_mon_fri3)/&comm_mon_fri4)*100) > 10
and &comm_mon_fri4 <> 0
then
call define(_col_,"style",
"style=[background=green]");
endcomp;
compute &comm_mon_fri2;
if (((&comm_mon_fri3-&comm_mon_fri2)/&comm_mon_fri3)*100) < -10
and &comm_mon_fri3 <> 0
then
call define(_col_,"style", "style=[background=red]");
else if (((&comm_mon_fri3-&comm_mon_fri2)/&comm_mon_fri3)*100) > 10
and &comm_mon_fri3 <> 0
then
call define(_col_,"style",
"style=[background=green]");
endcomp;
compute &comm_mon_fri;
if (((&comm_mon_fri2-&comm_mon_fri)/&comm_mon_fri2)*100) < -10
and &comm_mon_fri2 <> 0
then
call define(_col_,"style", "style=[background=red]");
else if (((&comm_mon_fri2-&comm_mon_fri)/&comm_mon_fri2)*100) > 10
and &comm_mon_fri2 <> 0
then
call define(_col_,"style",
"style=[background=green]");
endcomp;
run;