Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Imported Tables have to be Reloaded

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

Imported Tables have to be Reloaded

Hi.

I am facing this issue that whenever I import certain excel sheets to create reports out of them,every time I restart my servers those tables are not loaded again and the data items disappear.What is the Resolution for this.Do I need to run a query and generate an output table so that I can always load the table from the SAS LASR?

Kuber.

Thanks.


Accepted Solutions
Solution
‎10-07-2015 07:32 AM
SAS Employee
Posts: 35

Re: Imported Tables have to be Reloaded

Hi Kuber,

It sounds like the best solution would be to contact your administrator. The administrator can set the tables to reload when the server starts by putting them in a BASE library, or autoload to keep them loaded in general.

Best regards,

Lorrie

View solution in original post


All Replies
Super User
Posts: 7,433

Re: Imported Tables have to be Reloaded

Looks like the excel sheets are imported to datasets in the WORK library, which is deleted with all its contents when the SAS session closes. Use a permanent library as the target for the import.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 1,296

Re: Imported Tables have to be Reloaded

Hi Kuber,

It seems that your SAS Visual Analytics environment has the default configuration settings to handle imports. You may want to speak to your Administrator to configure the server so that tables loaded into the SAS LASR Analytics server via imports are automatically reloaded. This is described at SAS(R) Visual Analytics 7.1: User's Guide - After a SAS LASR Analytics Server Restart

Kind Regards,

Michelle

Contributor
Posts: 21

Re: Imported Tables have to be Reloaded

Nope these do not seem to work.Actually, it has been pretty much clearly mentioned in the vaug that after a server restart all files which are imported manually have to be redone again.What seems strange is when I use exactly thee same procedure to import a local sas data set in VA,I don't have to manually re -import this file to generate the explorations I created out of this data set,It gets reloaded as soon as I start LASR and reload all the tables.Can someone explain the logic to me??

Solution
‎10-07-2015 07:32 AM
SAS Employee
Posts: 35

Re: Imported Tables have to be Reloaded

Hi Kuber,

It sounds like the best solution would be to contact your administrator. The administrator can set the tables to reload when the server starts by putting them in a BASE library, or autoload to keep them loaded in general.

Best regards,

Lorrie

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 997 views
  • 0 likes
  • 4 in conversation