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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.