Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Online Modelling, Please Help..Thanks

Reply
Frequent Contributor
Posts: 95

Online Modelling, Please Help..Thanks

Hi All,

I would like to model response over time (in this case Order_Flag=1). For example, I have some customers (below)), who viewed an offer on line different dates, and they might click and order or not.  What's the approach here? I could use Logistic Regression, but I guess it's not recommended for repeated measures like the data below.

Also if I want to build a logistic regression and take the max(view_page_date), I might loose some responses, for example for the customer no 001000023769, his max date is on 23Oct2013 but he has responded on 28Jul2013. Coud you please recommend the best approach to model responses in this case?

Many Thanks

customerview_page_datemessageClick_FlagOrder_FlagVar1Var2Var3Var4
00100002376904Feb2013A00
00100002376921Feb2013A00
00100002376907Apr2013B00
00100002376928Jul2013A11
00100002376923Oct2013A00
00100004815703Jun2013A00
00100004815704Jun2013A10
00100004815712Jun2013A11
00100004815707Jul2013A00
00100004815708Aug2013A00
00100004815713Aug2013C00
00100004815706Oct2013A00
00100004815712Oct2013C00
00100005620902Jan2013D00
00100005620911Feb2013A10
00100005620912Feb2013D11


SAS Employee
Posts: 22

Re: Online Modelling, Please Help..Thanks

Hello and thanks for your question.  I consulted an expert on your recurrent event situation. This is an extension of survival analysis.  In this case it appears that the variable MESSAGE is a time-dependent covariate. Your situation would require some data preparation.

If the response is simply YES or NO for an order being placed, not a count of orders, then I think you could do this using the Survival node in Enterprise Miner.  However, it would require that you input a fully expanded data set.  The documentation for Enterprise Miner describes how to prepare your data in this manner.  Repeated measures analysis would not be required in this case due to the assumption of independent censoring.

A resource to learn more about survival data mining in general, in addition to the Enterprise Miner documentation, is a video on YouTube: Introduction to Survival Data Mining - YouTube

Frequent Contributor
Posts: 95

Re: Online Modelling, Please Help..Thanks

Many Thanks Laura, that's really helpful..

Ask a Question
Discussion stats
  • 2 replies
  • 265 views
  • 1 like
  • 2 in conversation