INSERT_SQL= Data Set Option

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

Valid in: DATA and PROC steps
Default: LIBNAME statement setting
Supports: All
Syntax
Syntax Description
Details

Syntax

INSERT_SQL=YES | NO

Syntax Description

YES

specifies to use the data source's SQL insert method to insert new rows into a table.

NO

specifies to use an alternate (DBMS-specific) method to add new rows to a table.

Details

SAS data sets generally have improved insert performance when INSERT_SQL=NO, which is the default for that SAS data sets. Other data sources might have inferior insert performance (or might fail) unless INSERT_SQL=YES. You should experiment to determine the optimal setting for your situation.
Copyright © SAS Institute Inc. All Rights Reserved.