Multiple Series and Multiple Reference Lines on Bar Graph

[KelseyB]

I am relatively inexperienced when it comes to SAS procedures related to graphs.  I would like to know what SAS procedure, if any, I can use to produce a graph in the format attached.  It contains two series graphed vertically as bars and three reference lines.  I have used proc gbarline for other graphs that contain only one vertical series and have two reference lines.  However, I am having difficulty getting that to work with the two series I need to graph.  Also, any help with the SAS code is greatly appreciated.  Thanks!

[ballardw · Accepted solution]

Instead of plotting two separate series it may be better to create a group variable to define which value is associated with the series.

With SGPLOT you would have a VBAR statement using that group variable. One example is here: http://support.sas.com/kb/43/731.html

Also you can add one or more REFLINE statements, which seem more appropriate from your example than a series.

A statement like:

Refline 90 / axis=y Label='Minimum Goal' labelloc=outside;

places a line across the graph at a value of 90 and places a label outside the graph with the text.

[Jay54]

Another way to make the same program work with multiple reference lines is to add the reference values to a column ( say A) in your data.  Then, you can use the column in thr REFLINE stmt:  refline a;  This works well if you have a panel, and want different reference lines by the panel variable (SGPANEL).

[KelseyB]

Thank you Sanjay.  This was helpful!