%RMDUPDSN

%RMDUPDSN Overview

The %RMDUPDSN macro generates the name of the data duplication control data set. This is a temporary SAS data set that will contain datetime ranges for the data that is being processed when duplicate-data checking is enabled. This information is also used by other duplicate-data-checking macros, such as %RMDUPCHK and %RMDUPUPD.

For supplied adapters, the %RMDUPDSN macro is automatically submitted in the staging code when duplicate-data checking is enabled. For user-written adapters, the duplicate-data checking is not automatically enabled. For information about how to enable duplicate-data checking in the user-written staging code, see Steps to Implement Duplicate-Data-Checking Macros.

%RMDUPDSN Syntax

%RMDUPDSN(
SOURCE=identifier );

%RMDUPDSN Required Arguments

SOURCE=identifier: specifies a unique three-character code that identifies the type of data. It should be the same as the value that was coded for the SOURCE= parameter of the %RMDUPCHK macro.

%RMDUPDSN Notes

This macro executes only one time. It creates a global macro variable, &RMDUPDSN, that contains the name of the data duplication control data set. The global macro variable is resolved by the %RMDUPDSN macro.

%RMDUPDSN Example

This example shows the creation of a control data set, called cpnts.dsn, that is used to detect data duplication.

%rmdupdsn(
   source=nts
   );