I am using vertical bars in SGPANEL. The categories are given by an underlying numerical value (acreage), which I formatted to create five meaningful categories ('very small, small, medium, large, very large). Accordingly, my graphs each have 5 bars.
SGPANEL arranges them left-to-right alphabetically: large-medium-small-very large-very small.
How could I order them as intended, left to right: very small-small-medium-large-very large. All I have manged is adding a prefix a, b, c, d, e to each, which works, but looks distracting.
(Version 9.4)
Looking forward to a solution.
Actually, you might want to use DISCRETEORDER=UNFORMATTED instead, since you said your underlying data is in numeric order.
Thanks!
Dan
On the COLAXIS statement, set DISCRETEORDER=DATA to retain your original data order.
Hope this helps!
Dan
Thank you for the very quick answer.
Are you saying that DISCRETEORDER=DATA will order my formatted values according to the values of the underlying unformatted variable?
Actually, you might want to use DISCRETEORDER=UNFORMATTED instead, since you said your underlying data is in numeric order.
Thanks!
Dan
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.