Data visualization with SAS programming

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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: 925

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

View solution in original post


All Replies
SAS Super FREQ
Posts: 925

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: 925

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 235 views
  • 0 likes
  • 2 in conversation