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