Proc SGPLOT: Overlay a bar chart with a trend line?

[zdblizar]

Hello!

I'd like to add a line to the chart produced from the code below. I want it to the serve the purpose of highlighting the difference between the two bars (in terms of the height of each bar). Does anyone know what additions I need to incorporate in the code below?

title height=20pt "Forecast Error by Method";

title2 height=17pt "Overall SBU Level for Year &Year";

proc sgplot data=Append_Table2_Year;

styleattrs datacolors=(red blue);

vbar Method / Response=Avg_Error_by_Method stat=mean datalabel datalabelattrs=(size=15pt) group=Method;

xaxis display=(nolabel)

labelattrs=(size=15)

valueattrs=(size=13);

yaxis labelattrs=(size=15) max=15;

keylegend / titleattrs=(size=12) valueattrs=(size=12) location=outside;

run;

Thanks!

-Z

[DanH_sas]

The simplest way is to add a VLINE using the same variables as the VBAR:

title height=20pt "Forecast Error by Method";
title2 height=17pt "Overall SBU Level for Year &Year";
proc sgplot data=Append_Table2_Year;
styleattrs datacolors=(red blue);
vbar Method / Response=Avg_Error_by_Method stat=mean datalabel datalabelattrs=(size=15pt) group=Method;
vline Method / Response=Avg_Error_by_Method stat=mean group=Method;
xaxis display=(nolabel)
labelattrs=(size=15)
valueattrs=(size=13);
yaxis labelattrs=(size=15) max=15;
keylegend / titleattrs=(size=12) valueattrs=(size=12) location=outside;
run;

Hope this helps!

Dan