How and when you should
use the duplicate-data-checking macros depends on the type of data
that you are using. The duplicate-data-checking macros and short descriptions
of the tasks that they perform are in the following list. Before
you begin to use these macros, review the following section entitled
“Implementing Duplicate-Data-Checking Macros.”
-
%RMDUPINT loads macro definitions
that are used by the other duplicate-data-checking macros.
-
%RMDUPDSN generates the name (WORK._DUPCNTL)
of the temporary SAS data set that will contain datetime ranges for
the data that is being processed into the active IT data mart.
-
%RMDUPCHK checks for duplicate
data by examining timestamps on data that is being read by the staging
code. This macro also writes to the temporary control data set.
-
%RMDUPUPD updates the permanent
control data sets with information from a temporary control data set
by way of the intermediate control data sets.