I have 10 tables that I have created 10 different sections. I am getting those tables from excel. Now the new month data came in and I need to refresh my reports. How do I upload those tables so I don't loose any changes i did in my reports?
Hello,
If you want to refresh your excel data in sas va, You have to use VDB(Visual Data Builder) in SAS VA,
SAS(R) Visual Analytics 7.1: User's Guide
Hope this will help you.
Thanks & Regards,
Teja SUrapaneni.
do you want to overwrite your tables ? or create different set of tables and re use the same report on those ?
if you don't need the previous data then just overwrite previous tables with the new data and report will show the latest data.
Hello,
Depending on what you want to do with your reports, you have two options:
Also, I just want to add that you can import the excel files directly from the designer (in addition to the data builder and the explorer). If you have your report open, click the Data tab and then on the "Add data source" icon. A window opens with the options for importing data.
Best regards,
Lorrie
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.