Dot Plot Conditional Formatting Question

Pdothard — Fri, 04 Apr 2014 16:59:41 GMT

I'm fairly new to SAS (Enterprise Guide 6.1). I'm using a dot plot within PROC SGPLOT to display observed to expected ratios with confidence limits based on the mean. I have everything functioning the way I need it so far, but now I want to throw in some color coding based on the value of the limits. Basically I want the limit and dot to change color if the upper limit is less than 1.0 or change to a different color if the lower limit is greater than 1.0. Here is what I have so far:

PROC SGPLOT DATA=WORK.SORTTempTableSorted;

refline 1.0/ lineattrs=(color=blue thickness=1.5pt) axis=x;

By Site;

dot AttendingNPI / response=DirectCostOERatio stat=mean

limitstat=clm limitattrs=(color=bib) categoryorder=respasc;

RUN;QUIT

topic Dot Plot Conditional Formatting Question in SAS Procedures

Dot Plot Conditional Formatting Question