topic Re: Is it possible to use "prefix" in proc metalib without creating duplicates? in SAS Data Management

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

Fredrik_Hansson — Wed, 25 Apr 2018 08:26:02 GMT

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.

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

SAS-Dan — Tue, 24 Apr 2018 14:39:33 GMT

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

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

Fredrik_Hansson — Wed, 25 Apr 2018 08:29:39 GMT

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