You can use the Mining Results transformation to create a job that creates a target table
from a SAS Enterprise Miner model.
In this example, a statistician uses SAS Enterprise Miner and historical home equity data
to build a data mining model to predict if a customer might default on a home equity
loan. After the statistician builds the model, it is registered in a SAS metadata repository
that a SAS Data Integration Studio developer can use. Additional customer data is
collected using SAS Data Integration Studio. The new data has the same customer
information but does not contain the predictions about a customer's probability for
defaulting on a home equity loan. The SAS Data Integration Studio developer applies
the SAS Enterprise Miner model to the new data source to generate the prediction of the
customer's probability to default on a home equity loan.
To use the Mining Results transformation, your SAS Enterprise Miner models must be
registered in the same metadata repository that contains the sources for your job. You
can use the SAS Enterprise Miner Configuration Wizard to associate your SAS
Enterprise Miner metadata repository with the metadata server that is used for your SAS
Data Integration Studio application. See the SAS Enterprise Miner online Help for more
information about how to use this wizard.
Note: It is recommended that you group your models in trees to make them easier to
find when using the Mining Results transformation.
For best performance, the target of a Mining Results transformation should have only
those columns that are required. These columns include the required input variables form
the source table and the output results that are specified in the SAS Enterprise Miner
Perform the following steps:
• “Create and Populate the Job” on page 701
• “Associate the SAS Enterprise Miner Model with the Job” on page 702
• “Run the Job and View the Output” on page 704
Create and Populate the Job
Perform the following steps to create and populate the job:
1. Create an empty SAS Data Integration Studio job.
2. Select and drag a Mining Results transformation from the Transformations tree in the
Data Transforms folder. Then, drop it in the empty job on the Diagram tab in the
Job Editor window.
3. Drag the cursor from the source table to the input port of the Mining Results
transformation. This action connects the source to the transformation. The following
display shows the process flow for the sample job.
Display A3.25 Mining Results Process Flow Diagram
Integrating a SAS Enterprise Miner Model with Existing SAS Data 701