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

Program to remove metadata registration for tables not loaded to memory

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Program to remove metadata registration for tables not loaded to memory

Hi experts

 

In our organisation some of the VAusers use the manuel import of data in the Data Exploration Tab a lot. Unfortunately they do not always remove data again when finish exploring. And a restart of the LASR-server wipes all manuel imported data resulting in growing amount of registered tables in the administraton tab in the VA hub. We also use Autoload.

 

I would like to create a SAS program that list all tables registered in a LASR server library and then check if they are loaded to memory in the LASR server and if not deletes the metadata registration for the table.

 

 

 

Have anyone already created a program to do something like that? 

 

We are runnning VA 7.3 (SAS 9.4)

Thanks

Lars

 


Accepted Solutions
Solution
‎08-23-2016 03:45 AM
SAS Super FREQ
Posts: 620

Re: Program to remove metadata registration for tables not loaded to memory

Hi

 

How about using Proc METALIB, see below for an example.

I assume that the list of libraries user can add their data is limited and can be hardcoded in the code.

 

The NOEXEC will not run the update rule, but will report what would be done.

 

proc metalib;
   omr ( LIBRARY="Visual Analytics Public LASR" );
   update_rule = (delete noadd noupdate);
   report = ( type=summary );
   noexec;
run;

You need to have a connection to the Metadata Server in order to run this code.

 

Bruno

View solution in original post


All Replies
Solution
‎08-23-2016 03:45 AM
SAS Super FREQ
Posts: 620

Re: Program to remove metadata registration for tables not loaded to memory

Hi

 

How about using Proc METALIB, see below for an example.

I assume that the list of libraries user can add their data is limited and can be hardcoded in the code.

 

The NOEXEC will not run the update rule, but will report what would be done.

 

proc metalib;
   omr ( LIBRARY="Visual Analytics Public LASR" );
   update_rule = (delete noadd noupdate);
   report = ( type=summary );
   noexec;
run;

You need to have a connection to the Metadata Server in order to run this code.

 

Bruno

New Contributor
Posts: 4

Re: Program to remove metadata registration for tables not loaded to memory

Hi Bruno,

Thanks for your reply. It solved my problem pretty easy Smiley Happy
Post a Question
Discussion Stats
  • 2 replies
  • 265 views
  • 5 likes
  • 2 in conversation