User-Written Staging Parameters :: SAS(R) IT Resource Management 3.7: Administrator's Guide

Parameters on the Staging Option

The following table shows the parameters that are available from the Staging option of the Staging Parameters tab in the Properties dialog box of the staging transformation.

Staging Parameters for User-written Staging Code
Staging Parameters Supported	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory
Future data	Discard Accept Terminate	Discard

Parameters on the Duplicate Checking Option

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	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
IDVAR variable for %RMDUPCHK macro	name of the SAS variable that identifies the system of machine that generated the input data	MACHINE
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	DATETIME
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	_eof
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.	00:29	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`.

Duplicate-Data Checking Parameters for User-Written Staging Code
KEEP value for %RMDHPCHK macro	number of weeks for which control data is to be kept	0	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.

Parameters on the User-Written Option

The following table shows these parameters that are available from the User-Written option of the Staging Parameters tab in the Properties dialog box of the staging transformation. For a detailed description of the staging parameters specific to the User-written Staging transformation, see Staging Parameters Tab.

User-Written Parameters for User-Written Staging Code
User-Written Parameters Supported	Values	Default Value
User-written code	directory path and file specification
Generate a macro variable with input table name	Yes No	Yes
Generate macro variables with target table names	Yes No	Yes
Generate a macro with target table options	Yes No	Yes
Generate Tabinfo and Varinfo tables	Yes No	No
Generate a macro to create target table ATTRIB statements	Yes No	Yes
Generate a macro to create computed columns	Yes No	Yes
Generate a macro to create column lists	Yes No	Yes
Generate a macro to assign columns to missing	Yes No	Yes