SAS Institute. The Power to Know

SAS/ACCESS(R) 9.2 Interface to PC Files: Reference

space
Previous Page | Next Page

The LIBNAME Statement for PC Files on Microsoft Windows

INSERT_SQL= Data Set Option



Determines 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
Syntax Description
See Also

Syntax

INSERT_SQL=YES | NO

Syntax Description

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.


See Also

To assign this option to a group of tables, use the INSERT_SQL= option specified in LIBNAME Options for PC Files on Microsoft Windows.

space
Previous Page | Next Page | Top of Page