Construct Libname from Metadata Definition

Patrick — Mon, 01 Jul 2019 09:09:43 GMT

Hi all,

Has anyone of you ever come across the need to construct a libname statement from its metadata definition?

What I've got is the libref. What I want is to query SAS metadata for this libref and fully generate the libname statement.

I know how to query metadata but I'm concerned that what I'm after could become quite involved to end up with something robust and production worthy.

What I hope someone here can provide: A) the expertise by having done that already so I get a better idea how complicated and involved this is and B) ideally some working code (partial or full solution)

A bit more background

I'm dealing with a situation where I've got a data driven process and one of the parameters my process gets is the source and target librefs (for Hadoop and CAS).

I can't pre-assign the libraries (at least not the ones for Hadoop) so I need to somehow generate the libname statements in my code - or if that's possible need to tell SAS to execute the metadata library definition which belongs to the libref I'm getting.

I'm using authentication domains so there is no need to derive the user and password from metadata should that be an issue.

The batch user executing the process will have all the metadata access required (but won't be an unrestricted user).

Environment is: SAS9.4M5 under RHEL.

Adding @ErikLund_Jensen because I believe you've done a lot in this area.

Thanks,

Patrick

Re: Construct Libname from Metadata Definition

andreas_lds — Mon, 01 Jul 2019 09:15:09 GMT

Maybe i am missing something, but can't you just use the libref in the libname-statement?

libname lina meta liburi="SASLibrary?@Libref='lina'";

Re: Construct Libname from Metadata Definition

Patrick — Mon, 01 Jul 2019 10:22:40 GMT

@andreas_lds wrote:

Maybe i am missing something, but can't you just use the libref in the libname-statement?
libname lina meta liburi="SASLibrary?@Libref='lina'";

OMG! No, you haven't missed anything. I did. How good I've asked before wasting time on a totally wrong approach. 🙂

topic Re: Construct Libname from Metadata Definition in SAS Programming

Construct Libname from Metadata Definition

Re: Construct Libname from Metadata Definition

Re: Construct Libname from Metadata Definition