Control ordering of categories when values are formatted - SGPLOT/SGPANEL

[JJBDubois]

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.

[DanH_sas]

On the COLAXIS statement, set DISCRETEORDER=DATA to retain your original data order.

Hope this helps!

Dan

[JJBDubois]

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?

[DanH_sas · Accepted solution]

Actually, you might want to use DISCRETEORDER=UNFORMATTED instead, since you said your underlying data is in numeric order.

Thanks!
Dan