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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1166 views
  • 0 likes
  • 3 in conversation