Main Tasks for Administrators - SAS Data Integration Studio 3.3 User's Guide - page 79

Table 6.3 User-Defined Variables from the Create Option Window

Option Name Macro Variable Description Type

Home runs HomeRuns Home runs hit String

Columns to print ColumnsToPrint Name of the columns

to print

Column

Report title ReportTitle Title of the report String

The Create Option window enables you to specify 10 types of variables:
￿ String (Default)
￿ Boolean True/False
￿ Boolean Yes/No
￿ Column
￿ File
￿ Float
￿ Integer
￿ Library
￿ Lookup
￿ Table

The variables that you define in the Create Option window are used in the
transformation template that you are creating. For example, string variables appear on
the Options tab in the properties window for the PrintHittingStatistics template.
Users display the Options tab in the window and enter values for each option.
The column variables appear on the Column Options tab in the properties window
for the transformation template that you are creating. For example, users display the
Column Options tab in the properties window for the PrintHittingStatistics template
and select the columns that correspond to the ColumnsToPrint variable of the Column
type.
For details about these option types and the constraints that can be set for most
types, see the Help topic in the Create/Edit Option window, which is one of the windows
in the Transformation Generator wizard. (You display this window by clicking the New
button in the Options window of the Transformation Generator wizard.)
To define the Home runs option, follow these steps:
1 Click New . A new row displays in the options table.
2 Enter Home runs in the Option Name field.
3 Enter HomeRuns in the Macro Variable Name field.
4 Enter a description of the variable in the Description field.
5 Select the Modifiable option in the Boolean properties check box
6 Keep the default value of String in the Type field. You must connect Home runs
option to the column for home runs in the source table. Because you are accepting
the default value of String in the Type field, users of the transformation can enter
the character-based name of the column when they configure the transformation
in a job.
7 Click OK to save the settings. The first row of the options list displays in the
Options window.