Databases Reference
In-Depth Information
options that are specific to that transformation. For example, the
Options
tab for the
Sort transformation has specific fields for sort size and sort sequence. It also has a
PROC
SORT Options
field where you can specify sort-related options that are not otherwise
surfaced in the interface. For example, you could use these fields to specify the options
that are described in the “Sorting” section.
In addition to the
Options
tab, some transformations have other tabs that enable
you to specify options that affect performance. For example, the properties window for
the SAS Scalable Performance Server Loader transformation has an
Other SPD
Server Settings
tab, which enables you to specify several SAS Scalable Performance
Server options.
Replacing the Generated Code for a Transformation with User-Written
Code
You can replace the generated code for a transformation with user-written code. For
example, you can edit the code that is generated for a transformation, save it, and then
set the transformation so that the customized code runs whenever the transformation is
executed. You can switch back to have SAS regenerate the step's code at any time. (The
edited version persists, but it is ignored.) Column mappings between the edited step
and its predecessor and successor steps remain intact.
You can use this method when you find that a transformation does not yet provide all
choices that you need in the point-and-click interface and the provided option fields. For
example, you could use this method to change the default join order that is generated for
the SQL Join transformation, as described in the section “Join Order and Performance.”
The following steps assume that a process flow has already been created, that you
know what modifications you want to make in the generated code for a particular
transformation in the flow, and that the flow displays in the Process Editor.
1
In the Process Editor, right-click the desired transformation and then select
Process
View Step Code
. Code is generated for the transformation and
displays in the Source Editor window.
2
In the Source Editor window, edit the generated code.
3
When finished, click the
X
in the upper right corner of the Source Editor.
4
Select
Yes
to save your changes. A file selection window displays.
5
From the file selection window, specify a path name for the edited code, and click
Save
. The edited code is saved to a file.
After you have save the customized code, the next task is to set the transformation so
that the customized code runs whenever the transformation is executed. Follow these
steps:
1
In the Process Designer window, select the transformation and then select
File
Properties
from the menu bar. The properties window for the transformation
displays.
2
Click the
Process
tab.
3
On the
Process
tab, select the
User Written
button. The
Type
field and related
fields become active.
4
In the
Type
field, select
File
.
5
Typically, you should accept the default host in the
Host
field.
Search WWH ::
Custom Search