Example Process Flow Diagram

Task 15. Creating a Score Card of the Good Credit Risk Applicants

You can use a SAS Code node to create a score card of the good credit risk applicants. The SAS Code node enables you to incorporate new or existing SAS code into process flows.

  1. Add a SAS Code node to the data mining workspace.

  2. Connect the Distribution Explorer node to the SAS Code node.

  3. Open the configuration interface to the SAS Code node.

  4. The SAS Code node provides a macro facility to dynamically reference the data sets and variables. Before you write code to screen for (score) the bad credit applicants, determine the name of the macro variable that references the score data set:

    1. Select the Macros tab.

    2. Notice that the name of the macro variable that references the score data set is &_MAC_3.

      [Macros tab of the SAS Code window showing macro variable &_MAC_3]

  5. Select the Program tab and type the following SAS code:

    [Program tab of SAS Code window showing user-entered SAS code.]

    The name of the D_GOOD_BAD_ variable is assigned when the score data set is processed. Make sure you use the correct variable name.

    The SAS DATA step reads the observations (customer applicants) from the score data set. The applicants who were assigned to the accept decision are written to the output data set GOODAPPS. These applicants are deemed to be credit-worthy.

    The PROC PRINT step produces a list report of the good credit risk applicants. The variable CUSTID identifies the good applicants.

  6. To run the code, click the Run tool icon ( [run node tool icon]).

  7. After the code runs, click Yes in the Message window. Select the Output tab to view the list of good credit risk applicants.

    [output tab of Code Node Results window showing output table of Good Credit Risk Applicants ]

  8. Close the SAS Code node.

space
Previous Page | Next Page | Top of Page