Specifies whether to save rows with non-unique (rejected) keys to a separate SAS table.
| Valid in: | SPD Server |
| Default: | NO |
| Restriction: | Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized). |
| Interactions: | Corresponding table option is UNIQUESAVE=. |
| Use in conjunction with the SPDSUSDS reserved macro variable. | |
| Note: | This macro variable has no effect when the SYNCADD= table option is set to YES. |
writes rejected rows to a separate, system-created table. This table can be accessed by a reference to the macro variable SPDSUSDS.
ignores duplicate rows rejected by an Append or Insert operation.
replaces the current row in the master table with the duplicate row from the Insert or Append operation, instead of saving the rows to a separate table. This setting is useful when updating a master table from a transaction table, where the two tables share identical column structures.
%let SPDSUSAV=YES
%put Set the macro variable spdsusds to &spdsusds;
title 'Duplicate (nonunique) employee numbers found in
EMPS';
proc print data=&spdsusds run;