topic Re: Libname META: Use existing library definition but change an option in SAS Programming

Libname META: Use existing library definition but change an option

Patrick — Fri, 12 Nov 2021 11:11:26 GMT

Hi all,

What I've got (SAS 9.4M7, RHEL):

- A pre-assigned library defined in SAS Metadata with engine Postgres

What I want:

Define a new library using all the definitions from the existing library but with one option changed.

What works:

What doesn't work:

And also the following doesn't work 😞

I know how I could define such a new library in metadata and I also know how I could create the libname statement directly in SAS ...but what I really would love to do is just use all the metadata already defined for the existing library and then just add/change one of the options.

Is there any reasonable way of doing this?

Thanks,

Patrick

Re: Libname META: Use existing library definition but change an option

LinusH — Fri, 12 Nov 2021 16:21:49 GMT

By looking in the documentation, it seems using other options than ones for connection/authorization is not supported.

I guess that you don't want to update the current libref with your inserbuff= for some reason?

A work-around could be to use the corresponding data set option, perhaps not ideal if you want to use this a lot.

Re: Libname META: Use existing library definition but change an option

Patrick — Sat, 13 Nov 2021 01:59:01 GMT

Thank you @LinusH for confirmation and for the proposition to use dataset options instead. I didn't think about the ds options which for my special use case is all I need.

The existing library definition comes OOTB as part of a SAS Solution and even though I don't believe that the default insertbuff value of one is required by the solution I'm very hesitant to change it only to support my additional and special site specific use case.