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! @Joy_SAS  ... View more

Hello SAS community , By the way I am currently learning SAS visual analytics and i have two doubts to be sorted which of those are : 1) I want to known whether if i have an list table that contains around 200000 rows of values and i just want to export these table into an excel sheet .So, i want to known that if i apply filters on those list table and if the number of rows exceeds 200000 it has to show an error that maximum number of rows has been reached . I just want to know if SAS Visual analytics can show those messages on the dashboard and if so how can this be done. 2) And another doubt if i have multiple list table  in multiple report, and those list tables can be sorted by date prompt for example year2020 to year2025. I only want it to directly export those years data from the list table .if I change the year to any other it must directly export that year's data from the list table?.If so how it can be done  Thank you, Surya  ... View more