Data visualization with SAS programming

Annotate with a By statement

Reply
Super Contributor
Posts: 291

Annotate with a By statement

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;
Super Contributor
Posts: 291

Re: Annotate with a By statement

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.
Ask a Question
Discussion stats
  • 1 reply
  • 132 views
  • 0 likes
  • 1 in conversation