cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kikorugeria
‎05-19-2017
  • 3 Posts
  • 1 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: How Do I Programatically Unload and Load a LASR Table?

by Fluorite | Level 6 in SAS Visual Analytics
‎01-22-2017 08:08 PM
‎01-22-2017 08:08 PM
Hi everyone,   Thanks for your replies. I found the solution through going to VA > Administrator. Click on File > Preference. Under SAS Visual Analytics Administrator > Manage Environment, tick the checkbox beside Record Actions as SAS Statements.   Then, perform whatever you need in the GUI and the code will be saved in /tmp. You may manually change the code as needed.   NOTE: Be careful on using this option. You may not want your /tmp folder to be flooded by sas files. You may want to uncheck this preference after getting what you need. ... View more

Re: How Do I Programatically Unload and Load a LASR Table?

by Fluorite | Level 6 in SAS Visual Analytics
‎01-19-2017 08:27 PM
‎01-19-2017 08:27 PM
Hi @ranjan7k, Thanks for the reply!   The solution you sent is maybe for tables directly loaded to the public LASR server. My table is from MySQL registered through SAS Management Console. This may be the reason why it doesen't work. Please see the following logs:   NOTE: The DROP and KEEP statements are not supported in procedure steps in this release of the SAS System. Therefore, these statements are ignored.   NOTE: You are trying to access a table in the TABLE statement that is not stored in the LASR Analytic Server. The IMSTAT procedure does not process data from non-LASR sources.   NOTE: PROCEDURE IMSTAT used (Total process time): real time 0.08 seconds cpu time 0.00 seconds ... View more

How Do I Programatically Unload and Load a LASR Table?

by Fluorite | Level 6 in SAS Visual Analytics
‎01-19-2017 01:06 AM
‎01-19-2017 01:06 AM
Hi,   I would like to create a SAS code that will unload a LASR table and reload it after. This is for updating the contents of the table. I have the hostname, port, user and password of both the physical and meta server. (Not sure if necessary. Maybe to setup the library where the table is located.)   So my desired output would be an unloaded/loaded LASR table when the code is run. Any ideas?   Thanks in advance!   Versions: SAS 9.4, SAS VA 7.3 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-19-2017 05:53 AM
Likes given to
View All
Quick links