## Churn Analysis with SAS Miner- Help

Solved
Occasional Contributor
Posts: 9

# Churn Analysis with SAS Miner- Help

Hello people,

I have a data set in excel,

there ise a target value on this data set, churners=1,  non-churner=0

I am a very beginner in SAS Enterperise Miner,

So I need to someone to help me, its very urgent for me pls.

I attached the data,  CHURN column is my target value (flag)

I want to understand which customers are churning,

I want to come up with initial findings on how churners are different than non-churners.

I must find at least one or two model, to understand the which columns are important for churners etc.

Accepted Solutions
Solution
‎09-22-2017 11:04 AM
Contributor
Posts: 71

## Re: Churn Analysis with SAS Miner- Help

Good suggestions so far.  Laura's suggestion is very good.

With a binary variable, many analysts (and business users) like the output from the Decision Tree node.  It can help you identify which variables might be important factors for churn and give you a model to score new data.

A REALLY good book to pick up is http://www.amazon.com/Data-Mining-Techniques-Relationship-Management/dp/0470650931. It has a great chapter on decision trees and likely covers survival analysis too.

Your data set has character variables that I *think* should be numeric.  For example, Revenue would look like 22.000.000 which I think should have been \$22,000,000 (or 22000000)?

When you import the data into EM, make sure you spend the time to set the roles and levels of each variable.  Churn would be Target and Binary.  There are a number of other variables that should be set to Binary too.

Customer could be set to a role of ID.

ChurnDep should be Rejected because it is redundant to churn.  The decision tree will split once on that variable and stop splitting.

Calibrat should also likely be rejected.

All Replies
Occasional Contributor
Posts: 9

## Re: Churn Analysis with SAS Miner- Help

SayGinf -

Are you looking at real data or just toy dataset? You may want to look into association rules - there are many papers SAS and academic, as well as someone in the telecom area.

SAS Employee
Posts: 22

## Re: Churn Analysis with SAS Miner- Help

As a new user of Enterprise Miner, a good place to start is the Getting Started guide.  It will walk you through an example using some data preparation nodes, modeling nodes, model comparison, and the scoring of new observations.  Find the correct version here: SAS Enterprise Miner

If at some point you have time stamps in your data, you might be interested in this SAS Global Forum paper on survival data mining.  This technique helps to predict not just if a customer will churn, but when: http://support.sas.com/resources/papers/proceedings12/132-2012.pdf

Solution
‎09-22-2017 11:04 AM
Contributor
Posts: 71

## Re: Churn Analysis with SAS Miner- Help

Good suggestions so far.  Laura's suggestion is very good.

With a binary variable, many analysts (and business users) like the output from the Decision Tree node.  It can help you identify which variables might be important factors for churn and give you a model to score new data.

A REALLY good book to pick up is http://www.amazon.com/Data-Mining-Techniques-Relationship-Management/dp/0470650931. It has a great chapter on decision trees and likely covers survival analysis too.

Your data set has character variables that I *think* should be numeric.  For example, Revenue would look like 22.000.000 which I think should have been \$22,000,000 (or 22000000)?

When you import the data into EM, make sure you spend the time to set the roles and levels of each variable.  Churn would be Target and Binary.  There are a number of other variables that should be set to Binary too.

Customer could be set to a role of ID.

ChurnDep should be Rejected because it is redundant to churn.  The decision tree will split once on that variable and stop splitting.

Calibrat should also likely be rejected.

☑ This topic is solved.