Data visualization with SAS programming

Multiple Series and Multiple Reference Lines on Bar Graph

Accepted Solution Solved
Reply
Contributor
Posts: 40
Accepted Solution

Multiple Series and Multiple Reference Lines on Bar Graph

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!


Accepted Solutions
Solution
‎09-25-2015 06:23 AM
Grand Advisor
Posts: 9,748

Re: Multiple Series and Multiple Reference Lines on Bar Graph

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.

 

 

View solution in original post


All Replies
Solution
‎09-25-2015 06:23 AM
Grand Advisor
Posts: 9,748

Re: Multiple Series and Multiple Reference Lines on Bar Graph

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.

 

 

SAS Super FREQ
Posts: 1,044

Re: Multiple Series and Multiple Reference Lines on Bar Graph

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

Contributor
Posts: 40

Re: Multiple Series and Multiple Reference Lines on Bar Graph

Thank you Sanjay.  This was helpful!

Post a Question
Discussion Stats
  • 3 replies
  • 373 views
  • 1 like
  • 3 in conversation