Indicates whether to let SAS delete multiple rows from a data source, such as a DBMS table.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | NO |
| Data source: | Amazon Redshift, Aster, Greenplum, HAWQ, Impala, Microsoft SQL Server, ODBC, OLE DB, PostgreSQL, SAP HANA, SAP IQ, Snowflake, Vertica, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | UPDATE_MULT_ROWS= LIBNAME option |
Table of Contents
specifies that SAS/ACCESS processing continues if multiple rows are deleted. This might produce unexpected results.
specifies that SAS/ACCESS processing does not continue if multiple rows are deleted.
Some providers do not handle this DBMS SQL statement well and therefore delete more than the current row:
DELETE…WHERE CURRENT OF CURSOR