04-03-2014 12:08 PM
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.
04-03-2014 12:22 PM
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. :-)
04-03-2014 12:41 PM
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
04-03-2014 01:18 PM
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.
04-03-2014 01:40 PM
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.