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;