LIBNAME Statement: PC Files on Microsoft Windows

INSERTBUFF

Sets the number of rows in a single insert.

Valid in:	DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default value:	LIBNAME option setting

Syntax
Syntax Description
Details
See Also

Syntax

INSERTBUFF=number-of-rows

Syntax Description

number-of-rows

specifies the number of rows to insert. The value must be a positive integer.

Restriction:

Microsoft Access only

Details

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.

If you assign a value that is greater than INSERTBUFF=1, the SAS indication of success or failure of the insert operation might be incorrect. The notes only represent information for a single insert, even when multiple inserts are performed.

If the DBCOMMIT= option is specified with a value that is less than the value of the INSERTBUFF= option, then the DBCOMMIT= option overrides the INSERTBUFF= option.

Note: When inserting with the VIEWTABLE window, 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]