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
Hi @Surya1203,
For your Concen #1, yes there would be a warning in the bottom right corner "Not all of the data appears because the client query row limit exceeds the server threshold. Please contact your administrator." or you will see "No data appears because too many values were returned from the query. Filter your data to reduce the number of values."
This can be resolved by adjusting the SAS Support - High cardinality thresholds in SAS® Visual Analytics for SAS® Viya®
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Hello,
I'm not sure I understand the second question. When you export the data from a list table object in a report, the resulting spreadsheet or CSV file will contain only the data that is present in the list table object. That is, any filter prompts that affect the list table will also affect the exported data. If I have a year prompt in my report and I select 2024, then only data from 2024 is exported.
What I'm not sure I understand is the part of your question about multiple reports. A report prompt will affect all of the pages and objects in that report, but it does not affect other reports. (Except if you create a report link with the Set prompt bar values of target report option, but that only applies when you open the other report through the report link.)
I'm not sure if that answers your question.
Sam
Hello Surya,
You want to automatically export the data from a report when you click the report link?
When you create a report link, there is an option to set the report prompts in the target report, which is one way to transfer the current view state from one report to another. But I don't know if there is a way to automatically export in the way you are saying.
Sam
Hi Surya,
If I understand your question correctly, you could make the page or report links point to a page with a list table. If you select Set prompt bar values of target report in the link options, the list table in the linked page or report should be filtered by the prompts selected earlier. The report viewer can then click on the object menu (top right of the list table object) and export the data in the list table:
@Surya1203 wrote:
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 .
For what very little it may be worth, large amounts of data and "Excel" are a bad combination. I've worked with this stuff since the row limit in Excel was 63K and have never seen anyone read all the rows of the exported data. If the result is to be consumed by another process then a text file like CSV is usually better as you don't need to worry about lost data from rows and most programs that accept external data will accept CSV. There may also be a benefit of not having "Excel" interpret your data into something else or a different appearance than desired.
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.