This preview shows page 1. Sign up to view the full content.
Unformatted text preview: age of the
equipment. You can import data sources from a variety of formats including SAS tables, relational databases, and
Microsoft Office Excel spreadsheets. Figure 1. Churn Modeling Table
SAS Rapid Predictive Modeler is included in SAS Enterprise Guide and SAS Add-In for Microsoft Office not only
because these are common interfaces for business analysts who are not experienced SAS programmers but also
because these products include a complementary set of data preparation, summarization, exploration and reporting
tasks to support the SAS Rapid Predictive Modeler analysis. Before you build a SAS Rapid Predictive Modeler model,
you might want to use tasks such as Characterize Data and Scatter Plot to summarize and explore your data to
understand trends and anomalies. Often in data mining the target variable contains a rare event; for example, if only
5% of your customers churn for a new offer, you want to make sure that you have a significant number of these
customers in your data set. You might want to oversample your data to make sure you select all customers who
churned and an equal number of customers who did not churn. Oversampling makes it easier for the model to find a
stable solution. Figure 2 displays the results of the One-Way Frequencies task, which indicate that the proportion of
churners to non-churners is about equal. Because the data have been oversampled, you want to specify prior
probabilities in the task as described in the next section of this analysis. 3 SAS Global Forum 2010 Customer Intelligence Figure 2. One-Way Frequencies for the Target Churn
BUILDING A CHURN CLASSIFICATION MODEL
SAS Rapid Predictive Modeler can be executed from within SAS Enterprise Guide or the SAS Add-In for Microsoft
Office. The task is identical in either product and requires a SAS Enterprise Miner license. Figure 3 shows that the
SAS Rapid Predictive Modeler task is organized along with the model scoring task within the Data Mining group.
Many business analysts prefer to work directly in Microsoft Office Excel. One benefit of using SAS Enterprise Guide
is that it provides project-based storage for your analyses along with a process flow diagram to manage the steps in
your analysis. Figure 3. Invoking the SAS Rapid Predictive Modeler Task within SAS Enterprise Guide 4 SAS Global Forum 2010 Customer Intelligence SAS Rapid Predictive Modeler prompts you for the input data source if an active data set is not already defined.
Figure 4 shows the Data panel of the SAS Rapid Predictive Modeler task. You assign modeling roles by dragging
them from the Inputs Variables list to the appropriate Modeling Roles list. You are only required to specify the
dependent variable (target) from your table that represents the value that you want to predict. The SAS Rapid
Predictive Modeler automatically decides whether variables are continuous or categorical. The SAS Rapid Predictive
Modeler automatically sets all variables as input variables (predictors), which is very co...
View Full Document
This note was uploaded on 09/30/2013 for the course FINANCE 4013 taught by Professor Jamescameron during the Summer '10 term at Ohio State.
- Summer '10