UNIQUESAVE= Table Option

Specifies to save observations with nonunique key values (the rejected observations) to a separate data set when inserting observations into data sets with unique indexes.

Valid in: INSERT statement
Category: User Control of SAS Index Usage
Interaction: Used in conjunction with SPDSUSDS= automatic macro variable
Data source: SPD Engine data set

Syntax

UNIQUESAVE= YES | NO

Arguments

YES

writes rejected observations to a separate, system-created table that can be accessed by a reference to the macro variable SPDSUSDS=.

NO

does not write rejected observations to a separate table (that is, ignores nonunique key values).

Details

When observations are inserted into a data set that has a unique index, the rejected observations are ignored. With UNIQUESAVE=YES, the rejected observations are saved to a separate data set whose name is stored in the macro variable SPDSUSDS. You can specify the macro variable in place of the data set name to identify the rejected observations.
Last updated: February 23, 2017