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

Arguments

Details

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.