BookmarkSubscribeRSS Feed
Kanyange
Fluorite | Level 6

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


2 REPLIES 2
lryan
SAS Employee

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

Kanyange
Fluorite | Level 6

Many Thanks Laura, that's really helpful..

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
  • 2 replies
  • 860 views
  • 1 like
  • 2 in conversation