topic Re: Control ordering of categories when values are formatted - SGPLOT/SGPANEL in Graphics Programming

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

JJBDubois — Tue, 06 Sep 2016 20:09:58 GMT

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.

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

DanH_sas — Tue, 06 Sep 2016 20:11:47 GMT

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

Hope this helps!

Dan

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

JJBDubois — Tue, 06 Sep 2016 20:14:57 GMT

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?

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

DanH_sas — Tue, 06 Sep 2016 20:14:19 GMT

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

Thanks!
Dan