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

SAS program to remove metadata registration of all unloaded tables from LASR

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

SAS program to remove metadata registration of all unloaded tables from LASR

[ Edited ]

Hello experts,

 

In our ogranization we are using SAS autoload for loading data into LASR. The VA users can unload their data by moving datasets to the unload folder in the autoload directory. However the metadata registration of the table won't delete autmatically.

 

So we are looking for a SAS program that checks all registered tables in a LASR server, then check if they are unloaded from memory and thereafter delete automatically the metadata registration for the table.

 

With automatically I mean.We will schedule this program. So we can run this program periodically. 

 

We are running on SAS VA 7.3 (Linux).

 

Thanks in advance.

 

 

 

 


Accepted Solutions
Solution
‎02-22-2018 04:41 AM
Trusted Advisor
Posts: 1,852

Re: SAS program to remove metadata registration of all unloaded tables from LASR

[ Edited ]

Hello @sergie89,

 

luckily SAS employee @Bruno_SAS already answered this question! Please refer to https://communities.sas.com/t5/SAS-Visual-Analytics/Program-to-remove-metadata-registration-for-tabl...

 

Please let us know if this helps you.

 

Kind regards,

Juan

View solution in original post


All Replies
Solution
‎02-22-2018 04:41 AM
Trusted Advisor
Posts: 1,852

Re: SAS program to remove metadata registration of all unloaded tables from LASR

[ Edited ]

Hello @sergie89,

 

luckily SAS employee @Bruno_SAS already answered this question! Please refer to https://communities.sas.com/t5/SAS-Visual-Analytics/Program-to-remove-metadata-registration-for-tabl...

 

Please let us know if this helps you.

 

Kind regards,

Juan

Occasional Contributor
Posts: 18

Re: SAS program to remove metadata registration of all unloaded tables from LASR

Posted in reply to JuanS_OCS

Hi @JuanS_OCS,

 

Thanks for your reply. The SAS program of @Bruno_SAS in https://communities.sas.com/t5/SAS-Visual-Analytics/Program-to-remove-metadata-registration-for-tabl... shows only a summary of tables that aren't loaded in LASR anymore, is that right ?

 

 

 

 

Occasional Contributor
Posts: 18

Re: SAS program to remove metadata registration of all unloaded tables from LASR

Hi @JuanS_OCS,

 

You're right the SAS program of  @Bruno_SAS works fine when I ignore noexec in the code!

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

I didn't read the code carefully.

Trusted Advisor
Posts: 1,852

Re: SAS program to remove metadata registration of all unloaded tables from LASR

Glad to know it was useful! 

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 505 views
  • 4 likes
  • 2 in conversation