topic Re: Legend order Proc sgplot hbar in Graphics Programming

Legend order Proc sgplot hbar

SB250 — Thu, 03 Apr 2014 16:08:32 GMT

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.

Re: Legend order Proc sgplot hbar

Jay54 — Thu, 03 Apr 2014 16:22:11 GMT

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

Re: Legend order Proc sgplot hbar

SB250 — Thu, 03 Apr 2014 16:41:00 GMT

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

Re: Legend order Proc sgplot hbar

DanH_sas — Thu, 03 Apr 2014 17:18:41 GMT

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.

Re: Legend order Proc sgplot hbar

SB250 — Thu, 03 Apr 2014 17:40:54 GMT

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.

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