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
Only by specifying it on the Oracle LIBNAME or CONNECT statement.
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.
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.
Is there a way to modify READBUFF default for Oracle SAS/ACCESS engine?
Only by specifying it on the Oracle LIBNAME or CONNECT statement.
@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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.