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

Solved
Occasional Contributor
Posts: 5

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

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.

Accepted Solutions
Solution
‎09-06-2016 04:22 PM
SAS Super FREQ
Posts: 975

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

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

Thanks!
Dan

All Replies
SAS Super FREQ
Posts: 975

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

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

Hope this helps!

Dan

Occasional Contributor
Posts: 5

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

[ Edited ]

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?

Solution
‎09-06-2016 04:22 PM
SAS Super FREQ
Posts: 975

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

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

Thanks!
Dan

☑ This topic is solved.