topic Re: Set libname defaults in SAS Enterprise Guide

Set libname defaults

Naz10 — Tue, 01 Aug 2023 21:31:02 GMT

How can I change defaults in the libname statement? The default option for READBUFF is 250 rows. How can I increase it without having to specify it in the libname statement?

Here is the link for the readbuff option for reference: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0uefiwns2056ln1bo8ukykj2724.htm

Thanks

Re: Set libname defaults

Quentin — Tue, 01 Aug 2023 21:56:56 GMT

It's usually easiest to specify it on the libname statement. But, as the docs you linked to show that it is also a data set option, you can specify it when you read in a data set as well, e.g.:

data want;
  set mydb.have (readbuff=1000);
run;

where mydb is a libref pointing to a library with some SAS/ACCESS engine that supports readbuff.

Re: Set libname defaults

Naz10 — Tue, 01 Aug 2023 22:19:47 GMT

Thanks you for the response!

I'm looking for an option to increase the default. Maybe somewhere in the config files? So far I've tried increasing BUFFSIZE, but that didn't help.

Re: Set libname defaults

Quentin — Tue, 01 Aug 2023 22:28:07 GMT

BUFSIZE is a system option, but READBUFF is not. I think READBUFF is only a libname option and a data set option. I think each SAS/ACCESS engine will have its own READBUFF default, appropriate for the engine. I don’t think there is a concept of a global READBUFF option.

Re: Set libname defaults

Naz10 — Tue, 01 Aug 2023 22:52:38 GMT

Is there a way to modify READBUFF default for Oracle SAS/ACCESS engine?

Re: Set libname defaults

SASKiwi — Tue, 01 Aug 2023 22:55:27 GMT

AFAIK, there is no way of setting a default value globally for READBUFF across any following LIBNAMEs. In fact I would caution against changing this from the default unless testing has proved that it improves performance. In my experience I've only changed the default in external database LIBNAMEs.

Re: Set libname defaults

SASKiwi — Tue, 01 Aug 2023 22:57:35 GMT

Only by specifying it on the Oracle LIBNAME or CONNECT statement.

Re: Set libname defaults

Patrick — Tue, 01 Aug 2023 23:08:42 GMT

@Naz10 wrote:

Is there a way to modify READBUFF default for Oracle SAS/ACCESS engine?

I'm pretty sure the answer is NO.

Often such DB access uses a functional user via an authdomain. If that's also the case for you then I'd define this library once in SAS Metadata and there you define all the options you like.

I normally change the defaults for:

readbuff

insertbuff

dbcommit

dbmaxtext

and pre-assign the library but set option defer=yes