BookmarkSubscribeRSS Feed
Question
Fluorite | Level 6

Hi All,

 

I would like to build a model to predict likelihood for an individual customer to return by week n etc..

I have hear Cox’s Proportional Hazard technique would be the appropriate technique. But I have never used it and your help would be mucch appreciated. Also how do I define my target in this case?...My data is like below.

 

Many Thanks

 

customer_id W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13
100 .   .   .   .   .   .   2.5 .   .   2.5 2.5 .   .  
101 4.5 2 3.5 2.5 2.5 2.5 .   .   4.5 5 .   .   .  
102 .   6.5 .   .   .   .   .   .   6.5 .   .   9 .  
103 .   5 10 .   .   .   9 8.5 13 .   7 18 7
104 2 2 .   .   .   .   .   .   2 .   4.5 2 .  
5 REPLIES 5
Reeza
Super User

What does your data represent? 

 

Also, please post a better formatted dataset, ideally as a data step. 

Question
Fluorite | Level 6

Hi Reeza,

 

The data represents the weekly customer transactions they have made in the last 13 weeks...the objective is to build survival model..When are customers more likely to return and purchase...For example, we are expecting the customer 101 to return on w9 etc..?

 
Hope It makes sense, if not please do not hesitate to give me a shout.
 
Thank You
 

customer_id

W1

W2

W3

W4

W5

W6

W7

W8

W9

W10

W11

W12

W13

100

2.5

2.5

2.5

101

4.5

2

3.5

2.5

2.5

2.5

4.5

5

102

6.5

6.5

9

103

5

10

9

8.5

13

7

18

7

104

2

2

2

4.5

2

.

Question
Fluorite | Level 6

Hi Reeza,

 

The data represents the weekly customer transactions they have made in the last 13 weeks...the objective is to build survival model..When are customers more likely to return and purchase...For example, we are expecting the customer 101 to return on w9 etc..?

 
Hope It makes sense, if not please do not hesitate to give me a shout.
 
Thank You
 

customer_id

W1

W2

W3

W4

W5

W6

W7

W8

W9

W10

W11

W12

W13

100

2.5

2.5

2.5

101

4.5

2

3.5

2.5

2.5

2.5

4.5

5

102

6.5

6.5

9

103

5

10

9

8.5

13

7

18

7

104

2

2

2

4.5

2

.

Question
Fluorite | Level 6

Hello,

 

Could anyone please respond to my message. I would be grateful..

 

Thank You

 

 

WendyCzika
SAS Employee

I'm not clear where you are trying to do this, but if you are programming in SAS, you might try the SAS Statistical Procedures community for help since the PHREG procedure is a STAT procedure.

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
  • 5 replies
  • 792 views
  • 0 likes
  • 3 in conversation