Programming the statistical procedures from SAS

Data requirement for Propensity Modelling, Please Help Thanks

Reply
Frequent Contributor
Posts: 95

Data requirement for Propensity Modelling, Please Help Thanks

Hi All,

I am planning to rebuild a Logistic Regression Model. In the past I have always built a Response model on data with no duplicates. One row per customer.

The current data I have now is as below. Basically we have different call_date per customer. Can we really build a Logistic Regression model on data with duplicates or shall I only take the max call date?? The model I have to rebuild was run on the duplicated data like below...Your help will be much appreciated! Many Thanks

Cust_nocall_dateaddress_id
115-May-1317162265
105-Jun-1317162265
106-Jun-1317162265
211-Apr-13426777
212-Apr-13426777
327-Jun-131604314
311-Jul-131604314
322-Jul-131604314
415-Aug-13518475
516-Sep-131617498
525-Sep-1312854216
614-May-131329769
701-Aug-13595104
816-Sep-1312885455
910-Oct-135022919
1005-Aug-133942622
Valued Guide
Posts: 2,108

Re: Data requirement for Propensity Modelling, Please Help Thanks

In general, the independence assumption is violated by having the repeated measures in the data.  Some suggestions:

First, rebuild the 'wrong' (the one with all the repeats) model to make sure you can reproduce it.

Do a sensitivity analysis.  Sometimes, the "wrong" model is still useful.

-- do a model based on the first call.

-- do a model based on the last call.

-- compare them to the original model.

If they all tell the same story, then use the first or last (whichever makes more sense in the analysis context).

If they tell different stories, then you have got more work to do to understand what is going on.

Another possibility for the sensitivity analysis is to use some sort of summary record for each customer.  It may be that things like number of calls are important markers.

Good luck with your modelling.

Grand Advisor
Posts: 16,933

Re: Data requirement for Propensity Modelling, Please Help Thanks

You can also consider collapsing the data to a customer level, and then having specific metrics attached to that customer, eg. Number of calls, number of sales, number of purchases

I don't know if you could use a repeated/random statement in GLIMMIX model instead as well, with a binary response. Random thought would need looking into.

Frequent Contributor
Posts: 95

Re: Data requirement for Propensity Modelling, Please Help Thanks

Many Thanks Reeza and Doc. that's really helpful!...Smiley Happy

Ask a Question
Discussion stats
  • 3 replies
  • 195 views
  • 3 likes
  • 3 in conversation