Maintaining Processes

Example: Defining Record Selector Process Properties

This example defines the Record Selector process properties to subset data from the ODD prior to loading it into the Detail Table output table.

For an example about adding a Record Selector process, see Example: Adding a Record Selector Process to a Process Flow.

Note: The following explanation describes the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, data stores, Job, and Process Flow exist. [cautionend]

Defining Record Selector Properties

In a Job Process Flow, a Record selector process can be added above the input source as follows:

[untitled graphic]

In the Job Process Flow, position the cursor on the Record Selector process icon, click the right mouse button, and select Properties. The Record Selection Process Attributes window displays.

General Tab	specifies a name, a description, an owner, and an administrator for the Record Selector process.
Source Code Tab	specifies who generates the code for the Mapping process, which for this example is SAS/Warehouse Administrator.
Execution Tab	specifies the host on which you want to run the Record Selector process, which for this example is the local host.
Output Data Tab	specifies the name and location of the intermediate work table(s) produced by the Record Selector process.
Options Tab	specifies options for generating the source code for the process. For this example, both options are selected, which is the default setting. The available options on this tab are Generate Access Code (ex. signon, libname) before step allows you to control whether SAS/Warehouse Administrator generates the code to access the preceding objects, such as sign on code, and the LIBNAME statement. If selected, SAS/Warehouse Administrator generates the code that is required to load or run the current object or process and the code that is required to access the objects or processes that precede the current one. It assumes that code has already been generated or is already in place to load or run the objects or processes that precede the current one. Set &SYSLAST macro variable at end of step allows you to control whether SAS/Warehouse Administrator generates code that sets the &SYSLAST macro variable to the name of the last table that was created or updated. Note: By default, both of the source code options are selected. If you specify that SAS/Warehouse Administrator generates code for the process (on the Source Code tab), then you should leave these source code options selected. If you are supplying the source code, you might need to select or deselect these options as needed.
Record Selection Tab	specifies a condition that the data must satisfy before SAS reads it. SAS/Warehouse Administrator will generate an SQL WHERE clause from the information you enter. You can enter the condition directly or click Define to open the Expression Builder window, in which you can specify the condition. For example, you could enter the following condition:

Top of Page