Create a Decision Flow

After you have published models and rule flows, they are available for use by other applications such as SAS Data Integration Studio. With SAS Data Integration Studio, you can combine models and rule flows into decision flows. In addition to models and rule flows, a decision flow specifies input sources. SAS Data Integration Studio maps the objects in the decision flow to objects in the input data source.
To create and run a decision flow in SAS Data Integration Studio:
  1. Right-click on the folder where you want to create the new job, and select Newthen selectJob. This tutorial creates the new job in My Folder.
  2. Enter a name for the new job, and click OK. This tutorial uses ScoreLoanDecision for the job name.
  3. If you are prompted to select a default application server, select SASApp, and click OK.
  4. Add the data source for the decision flow.
    1. On the Folders tab, expand Shared Datathen selectModel Managerthen selectQSTutorial.
    2. Drag the HMEQ_SCORE_PROB_OUTPUT data source to the Job Editor window.
  5. Add the data model.
    1. On the Transformations tab, expand Data.
    2. Drag the Model Scoring transformation to the Job Editor window.
    3. Right-click the Model Scoring transformation, and select Properties.
    4. Select the Models tab.
    5. Expand the Mining Results list, and select the Tree1 model.
    6. Click OK.
  6. Drag the cursor from the output port of the source table to the input port of the transformation. This action connects the source to the transformation.
  7. Add the rule flow.
    1. On the Folders tab, expand My Folders.
    2. Drag the Score_Loan rule flow to Job Editor window.
  8. Drag the cursor from the output port of the model to the input port of the rule flow. This action connects the model to the rule flow.
  9. Map the data source columns to the rule flow input terms.
    1. Right-click on the rule flow and select Properties.
    2. On the Inputs and Outputs tab, click map all columns to map the REASON column.
    3. Map the source column LANDLINE to the term HAS_LANDLINE. To map a column to a term, drag the column onto the term.
    4. Map the source column MODELSCORE to the term LOAN_SCORE.
    5. Click OK. When the column mappings are correct, the node status icon for the rule flow displays as a green check green node status checkmark.
  10. Add a table loader.
    1. Select the Transformations tab.
    2. Expand Access, and drag the Table Loader to the Job Editor window.
  11. Create a new output table.
    1. On the Folders tab, right-click on My Folder, and select Newthen selectTable. The New Table wizard opens.
    2. Enter LoanDecision for the table name, and click Next. The Table Storage window appears.
    3. Select QSTutorial for the Library, and click Next. (Use the default values for the remaining fields.) The Select Columns window appears.
    4. Select the Inventory tab.
    5. Expand Library, expand QSTutorial, select HMEQ_SCORE_PROB_OUTPUT, and click right arrow.
    6. Click Next. The Change Columns/Indexes window appears.
    7. Click Next, and then click Finish.
  12. Drag the new table to the Job Editor window.
  13. Drag the cursor from the OUTPUTS table of the rule flow to the input port of the table loader.
  14. Drag the cursor from the table loader to the input port of the output table.
  15. Click Run.
Decision Flow diagram created in SAS Data Integration Studio
Copyright © SAS Institute Inc. All rights reserved.