Hi SAS Community,
I hope you're doing well.
I'm currently working on a dataset in SAS and would like to arrange the columns in a specific order based on my personal preference, rather than the default or alphabetical order.
Specifically, I'm using SAS Visual Analytics and working with a crosstab table. I'd like to control the order in which the columns appear in the crosstab, regardless of how they are sorted in the dataset or metadata.
Is there a way to manually set or customize the column order within a crosstab in SAS Visual Analytics? Any guidance, steps, or best practices would be greatly appreciated.
Thank you in advance for your support!
You can see the expected result by creating a custom sort order.
Here is the overview how to create a custom sort order in SAS Visual Analytics:
Output
Before
After
For more information, please refer to SAS blog from the following link:
SAS Visual Analytics: creating a custom sort order - SAS Users
I'm sorry, but it is not clear for me what you want in crosstab. Could you please use our sample data like SASHELP.CLASS to create a screenshot of expected output in Excel to describe the requirement for the report?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.