Hi All, I am working on bank account data and trying to define the close date using SAS. The data looks like the table below. The definition of closed account is that if an account has 3 months of zero balance in a row, it will be considered as closed, regardless of what would happen after that. For example, the close date for acct 1 would be 4/1/2001 although it had balance again on 7/1/2001. If account does not have a close date, it will be considered open. For closed account, I want to calculate the average balance for the last 3 month, in this case it would be the average balance from 1/1/2001 to 3/1/2001. Can anyone help me with this? Thank you! Acct Month Balance Acct1 1/1/2001 1 Acct1 2/1/2001 2 Acct1 3/1/2001 3 Acct1 4/1/2001 0 Acct1 5/1/2001 0 Acct1 6/1/2001 0 Acct1 7/1/2001 7 Acct1 8/1/2001 6 Acct1 9/1/2001 5 Acct1 10/1/2001 0 Acct1 11/1/2001 0 Acct1 12/1/2001 0 Acct1 1/1/2012 3 Acct1 2/1/2012 2 Acct 2 1/1/2001 2 Acct2 2/1/2001 4
... View more