Hi Dr. Wicklin,

I am interested in doing something similar, but my dataset has more than 500,000 records. For each ID I would like to be able to check if they have at least two records which are minimum 30 days and at most 365 days apart, and if it is so then set an indicator for that.
sample records look like this:

ID Claim_date:
1 11/15/2002
1 12/03/2002
1 12/24/2002
1 01/07/2003
2 02/21/2003
2 06/22/2005
2 11/11/2005
2 05/17/2006

Any help will be appreciated.

Thanks and regards,

Tarun Arora