3 weeks ago
I'm trying to create a metadata table with a prefix and then keep it in sync using proc metalib.
This is my code:
proc metalib; omr ( library="/Shared Data/Hadoop/Visual Analytics HDFS" REPNAME="Foundation" ); folder="/Shared Data/Hadoop"; prefix="stg_"; select ("DT_HJARTA"); update_rule=(delete); report; run;
SAS documentation says "does not affect PROC METALIB processing, because the procedure uses the value of the SASTableName= attribute to compare the metadata to the tables in the data source.". (http://support.sas.com/documentation/cdl/en/lrmeta/60739/HTML/default/viewer.htm#a003241162.htm)
I don't agree.
First time I run the code a new metadata table is created, which is just what I want.
Next time I run the procedure above I get a duplicate metadata table. I just want to update the one I already have.
How can I achieve that and not create duplicates?
If I remove prefix="stg_"; the procedure works as I intended, but I really want to use prefix on some of my tables.
I use SAS9.4M3 on Linux.