Annotate with a By statement

Bill — Fri, 30 Apr 2010 18:18:59 GMT

I'm trying to use an annotate dataset with a BY statement in gchart. The procedure plots the charts correctly but only reads the first level of by variables in the annotate dataset.
ERROR: The by-variable drc from WORK.TOP10ALLBARS has the value T04, but in WORK.ANNO it has the value N01. This is not permissible with the NOTSORTED option, in which all by-groups must match exactly.

Is there a way to use annotate in a BY situation?
Code that I'm using just below.
Any help would be appreciated.!

proc sort data=Top10AllBars;
by Order Period DRC; /*DRC values are alike within an Order level*/
run;

data anno;
set Top10AllBars (keep=Period Pct DRC);
by DRC notsorted;
function='label';
xsys='2';
ysys='2';
midpoint=period;
y=Pct;
text=trim(left(put(Pct,4.2)));
size=1.5;
position='2';
color='black';
when='a';
output;
run;

proc gchart data=Top10AllBars;
by DRC notsorted;
vbar period/sumvar=pct
annotate=anno
;
run;

Re: Annotate with a By statement

Bill — Fri, 30 Apr 2010 18:42:21 GMT

I've found an answer at http://support.sas.com/kb/16/615.html. Given that I'm using 9.1.3, I'll need to use some macro programming.

topic Annotate with a By statement in Graphics Programming

Annotate with a By statement

Re: Annotate with a By statement