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?

Reply
Highlighted
New Contributor
Posts: 3

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

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.

Ask a Question
Discussion stats
  • 0 replies
  • 110 views
  • 0 likes
  • 1 in conversation