If you only have the beginning subscription dates, you will need some additional information to help identify predictors for someone subscribing. Assuming you have such variables, you have several options in how you prepare your data. One approach is to start by setting an observation window and a target window. For example, you might consider starting looking at the data available for potential subscribers from January through March to predict who would subscribe during May or June. The missing month (April) is intended to provide you some time to take action on those people the model identifies as being more likely to subscribe. If you have monthly data available, you can record those variables at lag1_var (end of March), lag 2_var (end of February), and lag3_var(end of January) to try and capture changes in behavior that might make someone more likely to respond/subscribe. For more distant time periods, you might average together behaviors (e.g. lag46_var for the average of the variables for October/November/December). You could then see how many of those people who had not subscribed by the end of the target period ended up subscribing in the 2-month period of May and June. The beauty of this type of approach is that it relies on recent behavior to predict future behavior. Since you are using rolling time periods, you can validate the model's performance at any time by updating the time intervals, and you can score current data to project subscriptions that will current in the 2-month period starting 30 days later. As new data becomes available, you update the corresponding lag variables so that you can score the newest data.
Hope this helps!
Doug
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.