LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies the number of rows in a single insert.
Valid in: |
DATA and PROC steps
|
Default value: |
LIBNAME option setting
|
INSERTBUFF=number-of-rows
|
- number-of-rows
-
specifies the number of rows to insert. The value must be
a positive integer.
SAS allows the maximum number of rows that is allowed
by the data source. The optimal value for this option varies with factors
such as network type and available memory. You might need to experiment with
different values to determine the best value for your site.
When you assign a value greater than INSERTBUFF=1, the SAS notes indicating
success or failure of the insert operation might be incorrect. These notes
are generated for a single insert. This is also true, when multiple inserts
are performed.
Note: PC Files Server does not support INSERTBUFF= option with a value
higher than 1 for writing data to Excel. It ignores this option when writing
data to Excel. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
If the DBCOMMIT= option is specified with a value that is less than
the value of INSERTBUFF=, then DBCOMMIT= overrides INSERTBUFF= option.
Note: When you are inserting with the VIEWTABLE window or the FSEDIT
or FSVIEW procedure, use INSERTBUFF=1 to prevent the data source interface
from trying to insert multiple rows. These features do not support inserting
more than one row at a time. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
DBCOMMIT and
LIBNAME Options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.