Program to remove metadata registration for tables not loaded to memory

[LarsEB]

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

[BrunoMueller · Accepted solution]

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

[LarsEB]

Hi Bruno,

Thanks for your reply. It solved my problem pretty easy 🙂