Solved: How to control the order of axis which is based on a categorical varia... - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

How to control the order of axis which is based on a categorical variable?

Posted 06-16-2017 05:54 PM (652 views)

I am doing a frequency bar chart with y-axis as frequency and x-axis as age group (such as 0-19, 20-29, ...). I want the axis arranged from youngest to oldest group, however, the default is going from highest frequency age group to lowest frequency age group, how can I rerrange the order of x-axis categories according to my preference?

1 ACCEPTED SOLUTION

Accepted Solutions

Opal | Level 21

Opal | Level 21

Re: How to control the order of axis which is based on a categorical variable?

Posted 06-18-2017 04:03 PM (741 views) | In reply to KubiK888

Try a custom sort on age group - you just right click on age group properties in the data source and it should be listed.

View solution in original post

1 REPLY 1

Opal | Level 21

Opal | Level 21

Re: How to control the order of axis which is based on a categorical variable?

Posted 06-18-2017 04:03 PM (742 views) | In reply to KubiK888

Try a custom sort on age group - you just right click on age group properties in the data source and it should be listed.