The LIBNAME Statement for Relational Databases

DELETE_MULT_ROWS= LIBNAME Option

Indicates whether to allow SAS to delete multiple rows from a data source, such as a DBMS table.

Default value:	NO
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Aster nCluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ

Syntax

DELETE_MULT_ROWS=YES | NO

YES: specifies that SAS/ACCESS processing continues if multiple rows are deleted. This might produce unexpected results.
NO: specifies that SAS/ACCESS processing does not continue if multiple rows are deleted.

Some providers do not handle these DBMS SQL statement well and therefore delete more than the current row:

DELETE ... WHERE CURRENT OF CURSOR