topic Re: How to: Metadata Object Exists in SAS Programming

How to: Metadata Object Exists

Patrick — Mon, 29 Aug 2022 08:49:42 GMT

There must be some simple SAS syntax for this ...but just can't figure it out.

I know the full metadata path and name for a metadata object (table). How can I test if this metadata object exists?

Re: How to: Metadata Object Exists

LinusH — Mon, 29 Aug 2022 08:52:54 GMT

Maybe you can try the METADATA_PATHOBJ function. It returns -3 if the object is not found:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrmeta/p1xunv8xz32p17n111eqr6edimy1.htm

Re: How to: Metadata Object Exists

Patrick — Mon, 29 Aug 2022 09:52:30 GMT

@LinusH I was a bit too quick to accept your post as solution.

Running below I get an rc of -2 which means "syntax error in path" even though I've copy/pasted the path directly from SMC as well as the table name.

data _null_;
    length id $20;
    length type $256;
    proj="";
    deftype="";
    id="";
    type="";

    rc=metadata_pathobj(proj,"/Folder1/Folder 2/Data/Visual Analytics(CLASS_2)",
                        deftype,type,id);

    put rc=;
    put id=;
    put type=;

run;

Not sure why that's not working given this is in the foundation repository and I'm creating this metadata table object with the same user (so not a permission issue).

....and I actually found very similar code in the template I've used as a starting point of my code. Hmmm....

Re: How to: Metadata Object Exists

Patrick — Tue, 30 Aug 2022 05:29:12 GMT

It worked once I used syntax as per https://support.sas.com/kb/42/872.html

Re: How to: Metadata Object Exists

LinusH — Tue, 30 Aug 2022 09:56:24 GMT

I couldn't find the actual dftypes to use, just seeing som examples, not a complete list or reference in the doc?

Re: How to: Metadata Object Exists

Patrick — Tue, 30 Aug 2022 10:31:55 GMT

The docu refers to SMC

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrmeta/p0i64g6kv9s3q3n1nqn17tap7l5b.htm