Hello, I am trying to SUM transactions based on a 7 day period looking for accounts with $2,000 or more in transactions and I am having difficulty with the code and have not found anything through google that would solve my problem. I have several months of transactional data by account and by date that I need to check if at any time in a 7 day period the account had $2,000 or more in transactions. Accounts can have more than 1 transaction per day and transactions can occur on any day (including holidays). The 7 day period can start/end on any day of the week. I was hoping to use two a DO loop to determine the start date and end date however I have been unsucessful and would appreciate any guidance. Below is a sample layout of the data I have: Acct Transaction date 1234 50.00 01/01/2012 1234 1500.00 01/03/2012 4275 500.00 01/07/2012 There are no negative numbers in the transaction amount field. Any help woudl be appreciated as I have spent the afternoon working on this without sucess. I only need to output records that meet the requirements. It almost feels like I need a do loop with a proc sql inside a do loop but I have been unable to find anyway to do so.
... View more
