Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

devon59

Technical User
Nov 30, 2005
18
0
0
US
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
 
data contact1;
set contact;
by accountid;
if first.accountid then temp=0;
if contactdate<=orderdate then temp+1;
run:

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top