How To Register A Model In Sas Enterprise Miner And Use In Enterprise Guide Step By Step

Working with Nodes That Assess

Score New Information

The final stride in nigh data mining issues is to create scoring lawmaking that you can use to score new information. For example, at present that you have a good predictive model for assisting donations, you lot tin employ that model to raw information that does not include the target variable TARGET_B. Thus you can automate the model scoring process of deciding which individuals are likely to donate.

There are several types of scoring including interactive, batch, and on-demand. Typically, interactive scoring is performed on smaller tables, while batch scoring is performed on larger tables. On-demand scoring includes single transactions that can exist performed in a real-time setting. There are as well different types of score lawmaking. By default, the score code that SAS Enterprise Miner creates is SAS code. It is as well possible to create Java or C code for integration into environments other than SAS. Additionally, SAS Enterprise Miner tin create PMML lawmaking, which is an XML representation of the model for scoring in other databases. In this topic, you will perform interactive scoring that produces SAS code.

You use the Score node to manage, edit, export, and execute scoring code that is generated from a trained model or models. The Score node generates and manages scoring formulas in the course of a single SAS Information step, which tin can be used in nigh SAS environments even without the presence of SAS Enterprise Miner.

In this example you use the Score node to score a score data set inside the process flow.

In lodge to add a data gear up to an Enterprise Miner procedure period diagram, you must ascertain information technology equally a information source kickoff.

In this task, you ascertain the DONOR_SCORE_DATA as a data source.

Right-click the Data Sources folder in the Project Console and select Create Data Source. The Data Source wizard opens.
In the Source box, select SAS Tabular array. Click Side by side.
In the Information Source Wizard - Select a SAS Table window, click Browse.
In the Select a SAS Tabular array window, double-click the DONOR library folder to expand it. Select the DONOR_SCORE_DATA table and click OK.

DONOR.DONOR_SCORE_DATA appears in the Table box of the Select a SAS Table window. Click Next.
Click Next in the Table Information window.
Select Bones in the Metadata Advisor Options window. Click Next. The Column Metadata window opens.
Redefine the metadata past setting the Role for the CONTROL_NUMBER variable to ID.
Click Next. The Data Source Attributes window opens.
In the Role box, select Score from the list to bespeak that this data set contains Score data.
Click Finish. The DONOR_SCORE_DATA information source appears in the Data Sources folder in the Projection console.

Drag the DONOR_SCORE_DATA data source from the DONOR library folder in the Project console into the Diagram Workspace. Place information technology well-nigh the Model Comparison node.
Drag a Score node from the Assess tab of the node toolbar into the Diagram Workspace. Connect both the Model Comparison node and the DONOR_SCORE_DATA information source to the Score node.
Run the Score node in social club to apply the SAS scoring lawmaking to the new data source.
View the Score node results when the node has finished running.

Equally you examine the results, notice these details:
- The SAS Code window displays code that was generated by the entire process menses diagram. The SAS score code can be used outside the Enterprise Miner environment for custom applications. The results also contain C and Java translations of the score lawmaking that can be used for external deployment.
- The Output window displays summary statistics for course and interval variables. Y'all tin can also view lists of the score input and output variables.
Select View Scoring in order to view the SAS, C, and Java score lawmaking.
Select View Graphs Bar Nautical chart in order to brandish a bar nautical chart of the values of the target variable for classification, decision, and segment output types, if applicable, for each data set.
Select View Graphs Histogram in order to brandish a histogram of the values of the predicted, probability, and profit output types for each of the information sets.
Close the Results window.
Click the ellipsis button to the correct of the Exported Data property in the Score node Properties panel in society to view the scored data.
Select the SCORE port table in the Exported Data - Score window.
Click Explore.
Examine the SCORE table. Values for predicted profit, expected turn a profit, and other variables were generated by the Score node for export.
Shut the Score table. Click OK to close the Exported Data window.

Drag a SAS Code node from the Utility tab of the nodes toolbar into the Diagram Workspace, and connect information technology to the Score node.
Right-click the SAS Code node and select Rename.
Blazon All-time Potential Donors on the Node name box.
In the SAS Code node Properties panel, click the ellipsis button to the correct of the Variables property to open the Variables table. The name of the average profit variable is EM_PROFIT and the proper name of the decision variable is EM_DECISION.
Coil to the right to meet the Characterization column. You tin widen the column to view its entire contents.
Close the Variables window.
In the SAS Lawmaking node Backdrop panel, click the ellipsis button to the right of the Code Editor belongings to open the Code Editor window.

The Code Editor window has three tabs: Macros, Macro Variables, and Variables. The Macros and Macro Variables tabs contain the organisation-defined macro variables and their values if these are already assigned and a list of macros provided by SAS.
Select the Macro Variables tab. The tab holds a list of macros that you can reference in your SAS code. Examine the Imports section of the Macro Variable list. A macro variable named EM_IMPORT_SCORE appears in this section. You can use the EM_IMPORT_SCORE macro variable to reference the score lawmaking that you import into the SAS Code node.
In the Grooming Code pane, enter the following code:
```
proc means data=&em_import_score northward min mean median max; form em_decision; var em_profit; run;  proc print information=&em_import_score noobs; var control_number em_profit; where em_profit gt .threescore; run;
```
Annotation: The PROC Means step calculates descriptive statistics for expected profit, and the PROC Print step generates a list of donors that exceed an expected profit threshold.
Click the Save All icon to save the code.
Close the Code Editor window.
Run the SAS Lawmaking node named All-time Potential Donors and view the results.
Select View SAS Results Log in club to view the SAS log.
Close the Results window.