Hi All
I have a library defined in SAS SMC called DDMD. Every week, I need to register new tables.I want to update Metadata thru a SAS Batch job.
For Example - Last week, I registered tables A, B & C. This week I need to register C, D & E. For the E-Guide user, the next day it should be only 3 tables visible in DDMD library, i.e C, D & E. I recieve theTableNames in a control file. It is possible that physically tables A & B still exists.
I am using the below code, the downside of this code is ... if physically any of the old tables still exists then it will not be deleted. The users will be able to see it.
libname AAA meta library="DDMD" metaout=datareg;
proc sql noprint;
select quote(trim(memname)) into :list separated by " "
from dictionary.tables
where libname="AAA"
;
quit;
%put Value of list: &list.;
proc metalib;
omr (library="DDMD");
update_rule(delete);
select (&list.);
report (type=detail);
run;
