LIBNAME Statement: PC Files on Microsoft Windows

INSERT_SQL

Sets the method that is used to insert rows into a data source.

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

Syntax

INSERT_SQL=YES|NO

YES: specifies that the SAS/ACCESS engine uses the data source's SQL insert method to insert new rows into a table.
NO: specifies that the SAS/ACCESS engine uses an alternate data- source-specific method to add new rows to a table.

To assign this option to a group of tables, use the INSERT_SQL option as specified in LIBNAME Options