Counting number of times the customer has been contacted: Count restart with 1 after each order

[devon59]

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

 

[bryanbayfield]

data contact1;
set contact;
by accountid;
if first.accountid then temp=0;
if contactdate<=orderdate then temp+1;
run: