SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 8
Accepted Solution

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

[ Edited ]

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.


Accepted Solutions
Solution
‎04-25-2018 04:29 AM
SAS Employee
Posts: 5

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

[ Edited ]
Posted in reply to Fredrik_Hansson

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

 

 

View solution in original post


All Replies
Solution
‎04-25-2018 04:29 AM
SAS Employee
Posts: 5

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

[ Edited ]
Posted in reply to Fredrik_Hansson

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

 

 

Occasional Contributor
Posts: 8

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

Thank you! I will install it as soon as possible. :-)
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 219 views
  • 1 like
  • 2 in conversation