Data visualization with SAS programming

Legend order Proc sgplot hbar

Reply
New Contributor
Posts: 3

Legend order Proc sgplot hbar

I've made a series of horizontal grouped (clustered) bar charts with proc sgplot. Is there a way to change the order of the legend? For some reason the legend is in reverse order from what is in the graph and in descending order. I know I can do it the way I want with proc gchart, but I'm just wondering if there is a way to do it with proc sgplot.

SGPlot.png

SAS Super FREQ
Posts: 1,134

Re: Legend order Proc sgplot hbar

Group values are in data order.  SAS 9.4 SGPLOT supports SORTORDER for legend.  SAS 9.3 SGPLOT does not have this feature.

You have two options.

1 - Put the group values in the correct order in the data.  Or,

2 - use the TMPLOUT option to save the GTL template, and then in the DISCRETELEGEND statement, add SORTORDER= ASCENDINGFORMATTED | DESCENDINGFORMATTED.    Welcome to GTL. :-)

New Contributor
Posts: 3

Re: Legend order Proc sgplot hbar

I'm not sure what you mean by the first option. I'm only referring to the order of the subgroup bars and the legend. The graph shows 0 on top, then 1 and 2. But the legend shows 2,1,0.

I've never used GTL. I guess I will  probably just use proc gchart and have GTL on my list of things to learn Smiley Happy

SAS Super FREQ
Posts: 925

Re: Legend order Proc sgplot hbar

What Sanjay was saying in the first item was that the order of the groups in the legend is determined by the order of the group values as they occur in the data. Therefore. if you use PROC SORT to sort your data by the group variable first, you should get the legend in the 0-2 order. If this is not the case, please let us know.

New Contributor
Posts: 3

Re: Legend order Proc sgplot hbar

My data is sorted in ascending order for the subgroup variable (var1) 0,1,2. It is strange.

If I remove the GROUPDISPLAY=CLUSTER option, then I get the following chart. The legend is in the "correct" order.

SGPlot2.png

If I plot it as a vertical bar chart, the legend is also in the "correct" order.

SGPlot.png

Ask a Question
Discussion stats
  • 4 replies
  • 1308 views
  • 0 likes
  • 3 in conversation