07-18-2013 12:42 PM
I have 3 dates for each customer. An offer Creation date, A contact date ( not all are contacted, and an offer accept date ( customer can accept without being contacted. I want help to create following data shown in table.
The "Status Day 0" is the offer creation date. For each day i need to classify the customers to one of the following statuses:
|1||offer accepted after contact|
|2||offer accepted without any contact|
|3||Offer still not accepted but contacted|
|4||offer still not accpted but were not contacted|
I appreciate all your help.
07-18-2013 01:10 PM
I would create a long version of my dataset first (something like below, which is untested). And then transpose it, this seems easier because you don't have to know how many days you have ahead of time. Then you can fill in the missing days with the last observation using arrays.
I also haven't worked out the if conditions, but that seems relatively straightforward.
end_loop=max(offer_creation, contact_date, acceptdate);
do date_ordered=offercreation to end_loop;
*Create if conditions here to assign status to each day;
if date_ordered=offercreation then status=4;
else if ...