The following table
shows the parameters that are available from the
Duplicate
Checking option of the
Staging Parameters tab
in the
Properties dialog box of the staging
transformation.
Duplicate-Data Checking Parameters for User-Written Staging
Code
Staging Parameters Supported
|
|
|
|
Enable duplicate checking
|
|
|
|
Duplicate checking options
|
|
|
|
IDVAR variable for %RMDUPCHK
macro
|
name of the SAS variable
that identifies the system of machine that generated the input data
|
|
|
TIMESTMP variable for
%RMDUPCHK macro
|
name of the SAS variable
that contains the datetime stamp that uniquely identifies the time
of the event or interval that is being recorded
|
|
|
ENDFILE variable for
%RMDUPCHK macro
|
name of the SAS variable
that is used as the END= keyword for the SAS INFILE statement that
reads the raw data file
|
|
|
INT variable for %RMDUPCHK
macro
|
maximum time gap (or
interval) that is to be allowed between the timestamps on any two
consecutive records from the same system or machine.
|
|
If the interval between
the timestamp values exceeds the value of this parameter, then an
observation with the new time range is created in the control data
set. This is referred to as a gap in the data.
The value for this parameter
must be provided in the format hh:mm, where hh represents hours and
mm represents minutes. For example, to specify an interval of 14 minutes,
use INT=0:14. To specify an interval of 1 hour and 29 minutes, use
INT=1:29.
|
KEEP value for %RMDHPCHK
macro
|
number of weeks for
which control data is to be kept
|
|
Because this value represents
the number of Sundays between two dates, a value of 2 (the default)
results in a maximum retention period of 20 days.
|