Is it possible to use "prefix" in proc metalib without creating duplicates?

[Fredrik_Hansson]

Hi!

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.

EDIT: Wrong version. We run SAS9.4 M4.

[SAS-Dan · Accepted solution]

Fredrik,

Thank you for posting on our communities site and letting us know of your issue.  You are correct - the behavior your are experiencing is not intended.  There is a fix to this particular issue so that your tables are updated, not duplicated.  You can find all the details, including how to pursue the fix by following this link:  http://support.sas.com/kb/61/614.html

Regards,

Dan

SAS Product Management

[Fredrik_Hansson]

Thank you! I will install it as soon as possible. 🙂