Maintaining Processes

Example: Editing Load Process Properties to Supply User-Written Code

With its default settings, you might not need to edit the Load process. However, for example, if you intend to supply user-written code for the Load process and the default is so that the code is generated by SAS/Warehouse Administrator, you must edit the Load process properties. Also, SAS/Warehouse Administrator cannot generate source code for an ODD or a Detail Logical Table Load process. Therefore, for those data stores, you must edit the Load process to supply the user-written code.

For an example of a resulting Load process, see Editing the Load Process.

Writing Code for a Load Process

Load process code creates a table or view. SAS provides a number of tools that you can use to write Load process code:

DATA step
SQL procedure
Query window
External File Interface (EFI)
SAS/ASSIST software
SAS/TOOLKIT software

For more information about writing Load process code, click Help on the data store's Load process attributes window. Then, select the link for the Source Code tab, then select User-Written Source Code.

Editing Load Step Properties

The Load process is included automatically in the Process Flow. However, the Load process does not have its own icon; it is associated with the output table.

[untitled graphic]

In the Job Process Flow, position the cursor on the output table, click the right mouse button, and select Edit Load Step. The Load Process attributes window for the data store displays.

Source Code Tab

specifies who supplies the source code for the Job, which for this example is user-written code.

[untitled graphic]

Click Edit to open an editing window in which you can enter, view, or update the specified code. An example of Load process code follows:

[untitled graphic]

Note: For the output table, its properties window Columns tab must match the columns to be loaded. If not, the Mapping process will not match the columns loaded into the data store. [cautionend]

Execution Tab

specifies the host on which you want to run the Load process. This example specifies the local host.

[untitled graphic]

Post Processing Tab

specifies code to be executed after the data store is loaded. For example, you might want to register code that sends an e-mail indicating that the Load process has finished.

[untitled graphic]

Top of Page