Hi,I would appreciate your help. Here's what I am trying to do. I have a dataset that tells me customerID, contact date, order date. I want to find out how many times on average customers have been contacted before they place order.
Right now, I have my code as
data contact1; set contact;
by accountid contactdate orderdate;
if first.accountid then do;
temp=0;
end;
temp+1;
run:
This code create a column call temp that keep counting 1,2,3,4... for each accountid. However, I have this count to reset once contactdate>orderdate. How do I do that?
Any help would be very much appreciated.
Thank you
Right now, I have my code as
data contact1; set contact;
by accountid contactdate orderdate;
if first.accountid then do;
temp=0;
end;
temp+1;
run:
This code create a column call temp that keep counting 1,2,3,4... for each accountid. However, I have this count to reset once contactdate>orderdate. How do I do that?
Any help would be very much appreciated.
Thank you
