topic Re: Vertical Bar Chart question in SAS Programming

Vertical Bar Chart question

morganmetzger — Thu, 10 Dec 2020 15:08:38 GMT

Hello, I am trying to change the order of my vertical bar chart. I attached a word document of them for reference. The first one is how they are supposed to look in the order of Iowa, Mississippi, Utah. Mine are coming up in a different order and was wondering how I can program them to come up in the same order as the first graph.

Thanks!

Re: Vertical Bar Chart question

mlensing — Tue, 08 Dec 2020 17:50:28 GMT

One workaround you could try would be to assign numeric values to each of the states (maybe in a temp dataset first), use a proc sort to sort the states in ascending alphabetical order, and then assign format names of each state names to have your states appear in the correct order on your graph..

This SAS Communities post also seems to have a similar situation to yours with other solutions you could try.

Re: Vertical Bar Chart question

ballardw — Tue, 08 Dec 2020 17:53:06 GMT

Microsoft office documents are likely sources of macro viruses and such. So many on this forum will not open them from either individual or organization policy.

Code should be shared as text pasted into a code box opened on the forum with either the </> or "running man" icon.

The VBAR statement has an option CATEGORYORDER= which can take the parameter of

RESPASC (ascending order) or RESPDESC (descending order).

Be aware that with character values capitalization and leading spaces can be used in determining order and may not match expected order.