topic Re: Multiple Series and Multiple Reference Lines on Bar Graph in Graphics Programming

Multiple Series and Multiple Reference Lines on Bar Graph

KelseyB — Tue, 22 Sep 2015 21:22:48 GMT

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!

Re: Multiple Series and Multiple Reference Lines on Bar Graph

ballardw — Tue, 22 Sep 2015 21:53:10 GMT

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.

Re: Multiple Series and Multiple Reference Lines on Bar Graph

Jay54 — Wed, 23 Sep 2015 00:28:22 GMT

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).

Re: Multiple Series and Multiple Reference Lines on Bar Graph

KelseyB — Wed, 23 Sep 2015 13:26:02 GMT

Thank you Sanjay. This was helpful!