Databases Reference
In-Depth Information
Specify SAS Code for the Transformation
In the SAS Code window, enter SAS code for the transformation. The following
display shows the code that could be entered for the current example.
Display 6.4 Sample Transformation Code
A number of macro variables appear in the code. The variable &SYSLAST is a
system variable that refers to the last data set created. The &SYSLAST variable
enables a transformation in a process flow diagram to use the output from the previous
transformation.
The other variables that are shown in the previous display, such as
&ColumnsToPrint, are user-defined variables. Any user-defined variables must be
defined in the Create Option window that is displayed later in the wizard.
After you have finished writing your SAS code, click Next . The Options window
displays.
Note: The user of the transformation supplies values for these user-defined
variables when the transformation is included in a job. In addition, the % character is
used to escape single quotation marks, double quotation marks, and the %, (, and
) characters. The practice of escaping these characters prevents problems with
mismatched quotation marks or parentheses. You need to use the %unquote() function
when you use a macro variable that contains SAS code. ￿
Create User-Defined Variables
In the Create Option window, define any user-defined variables that you used in the
SAS Code window. The following table shows the values that you would enter for the
user-defined variables that are shown in Display 6.4 on page 78.
 
Search WWH ::




Custom Search