BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PITERSON_X_TB
Calcite | Level 5

Hello,

 

I am a beginner in modeling and preparation of data for modeling.
Currently, we prepare the data for modeling churn customers in the TELCO and I have the following problem.
I churn for the period 201505 and to join these data variables for say 6-9 months before the churn rate and it will targer churn = 1.
The problem is with the TARGET = 0, which here should take contracts?
Is such a database only from the period 201411 and variable calculated from 201411 to 201505? (only those which do not churn)?
Should I take the entire database, or for example if I examine the commercial churn (201505) to take the base of such 201411,
which will EOP (End of period) in the coming months (eg 6 months)?

Apologizes for probably a trivial question, but as I wrote above, I am a beginner.
Thank you very much for your help, advice, suggestions on what I should pay attention to.

Thanks
Pete

Qb-eg
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

http://www2.sas.com/proceedings/sugi27/p114-27.pdf

 

You can search lexjansen.com with the terms: survival analysis with churn from a telecom company

 

You'll find many papers and hopefully something that works for you.

View solution in original post

4 REPLIES 4
Reeza
Super User
I'm having a hard time understanding your question.
But here's a paper on using survival analysis with churn from a telecom company, including their sampling specifications.

I like survival analysis for churn because it helps to account for customers who are still active as well as those that churn.
mmyrto
Quartz | Level 8

where is the paper on this subject? Im interested in doing the same thing and I just want to get an idea on how the data should be structured. For example i want to get propensity to churn in the next 30 days in telco. So i have my customer base this month should i go 12 months back and have data for each month?

WendyCzika
SAS Employee

Here are a couple resources on survival data mining.

 

http://support.sas.com/rnd/app/video/index.html#txtmine

(See videos Introduction to Survival Data Mining and New Features in the SAS Enterprise Miner 12.3 Survival Node)

 

and this tip that gives a link to an example SAS Enterprise Miner template and accompanying documentation for survival data mining:

https://communities.sas.com/t5/SAS-Communities-Library/Survival-Data-Mining-by-Example-in-SAS-Enterp...

 

https://support.sas.com/resources/papers/proceedings12/132-2012.pdf

 

Reeza
Super User

http://www2.sas.com/proceedings/sugi27/p114-27.pdf

 

You can search lexjansen.com with the terms: survival analysis with churn from a telecom company

 

You'll find many papers and hopefully something that works for you.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 3775 views
  • 0 likes
  • 4 in conversation