Counting number of times the customer has been contacted: Count restart with 1 after each order
Counting number of times the customer has been contacted: Count restart with 1 after each order
(OP)
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
RE: Counting number of times the customer has been contacted: Count restart with 1 after each order
set contact;
by accountid;
if first.accountid then temp=0;
if contactdate<=orderdate then temp+1;
run: