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.
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. 🙂
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
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.