05-03-2016 10:08 AM
How can I delete registered tables from metadata library using sas code?
I know that using
update_rule=(delete) within proc metalib procedure deletes the table if they no longer exists in the physical path
but i want to keep them in the physical path.
05-03-2016 10:25 AM
PROC METALIB does not delete the physical data but if the table exists in the physical path it does not remove it from
the metadata library .
For wxample , I have library test defined in metadata with the following properties:
- location /Shared Data
- selected items - /path/test
I have registered the table class in this library and now I want to delete it from the library but still keep it in the /path/test .
how can I do it?
05-04-2016 05:01 PM
What about going through the entire library using an EXCLUDE statement to not process the tables you do not want registered?
proc metalib; omr (libid="XXXXXXX"); exclude table1 table2......; run;
Personally I avoid registering tables in metadata where possible so I don't have these administration problems