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*/
set Top10AllBars (keep=Period Pct DRC);
by DRC notsorted;