Set libname defaults

[Naz10]

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

[Quentin]

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.

[Naz10]

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.

[Quentin]

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.

[Naz10]

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

[SASKiwi · Accepted solution]

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

[Patrick]

---

@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

[SASKiwi]

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.