BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sergie89
Quartz | Level 8

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.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JuanS_OCS
Amethyst | Level 16

Hello @sergie89,

 

luckily SAS employee @BrunoMueller 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

4 REPLIES 4
JuanS_OCS
Amethyst | Level 16

Hello @sergie89,

 

luckily SAS employee @BrunoMueller 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

sergie89
Quartz | Level 8

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 ?

 

 

 

 

sergie89
Quartz | Level 8

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.

JuanS_OCS
Amethyst | Level 16

Glad to know it was useful! 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

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