BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Patrick
Opal | Level 21

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: 

Patrick_0-1636714621536.png

What doesn't work:

Patrick_1-1636714663319.png

Patrick_2-1636714714998.png

 

And also the following doesn't work 😞

Patrick_3-1636715137226.png

 

Patrick_4-1636715327659.png

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

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.

Data never sleeps

View solution in original post

2 REPLIES 2
LinusH
Tourmaline | Level 20

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.

Data never sleeps
Patrick
Opal | Level 21

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.

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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