Hi All,   I have been trying code the following logic but I have not had any lucky with this.   I need to aggregate an amount by account and review the date of each fee(ATM_OD) and calculates amount of fees for 60-days prior with the following conditions:   2. If the balance on the day of the fee(ATM_OD) is less than the aggregate value then that fee is owed to the account and is part of the aggregate amount. 3. If a fee is owed, it becomes part of the 60-day aggregate to determine if the next fee is due to the account   please see the following table with the flow of this logic.   any help is appreciated    Account  GROUP POST_DT prior60 Balance Fee_Amount Fee_Amount_Updated Comments Aggregate_Amount prior60 Condition (Balance < Aggregate Value)                  1 ATM_WITH 26Sep2016 28Jul2016  .   $              0.50      $                            0.50                      1 ATM_WITH 26Sep2016 28Jul2016  $             -    $              0.50      $                            1.00                      1 ATM_WITH 26Sep2016 28Jul2016  $             -    $              0.50      $                            1.50                      1 ATM_OD 30Sep2016 01Aug2016  $ (150.14)  $            36.00 0.00  The fee amount should be updated for 0 since the condition is False   $                            1.50  $      1.50  FALSE                  1 ATM_WITH 06Oct2016 07Aug2016  .   $              0.50      $                            2.00                      1 ATM_WITH 12Oct2016 13Aug2016  $             -    $              0.50      $                            2.50                      1 ATM_WITH 26Oct2016 27Aug2016  $             -    $              0.50      $                            3.00                      1 ATM_INQ 26Oct2016 27Aug2016  $             -    $              0.50      $                            3.50                      1 ATM_OD 31Oct2016 01Sep2016  $   (52.86)  $            38.00 0.00  The fee amount should be updated for 0 since the condition is False   $                            3.50  $      3.50  FALSE                  1 ATM_OD 14Nov2016 15Sep2016  $ (187.87)  $            38.00 0.00  The fee amount should be updated for 0 since the condition is False   $                            3.50  $      3.50  FALSE                  1 ATM_OD 16Nov2016 17Sep2016  $      (2.00)  $            38.00 38.00  The fee amount Keeps the value   $                          41.50  $      3.00  TRUE                  2 ATM_WITH 05Jan2017 06Nov2016  .   $              0.50      $                            0.50                      2 ATM_INQ 13Jan2017 14Nov2016  $             -    $              0.50      $                            1.00                      2 ATM_INQ 20Jan2017 21Nov2016  $             -    $              0.50      $                            1.50                      2 ATM_OD 23Jan2017 24Nov2016  $ (231.29)  $            38.00 0.00  The fee amount should be updated for 0 since the condition is False   $                            1.50  $      1.50  FALSE                  2 ATM_OD 24Jan2017 25Nov2016  $ (493.54)  $            38.00 0.00  The fee amount should be updated for 0 since the condition is False   $                            1.50  $      1.50  FALSE                  2 ATM_OD 27Jan2017 28Nov2016  $      (1.00)  $            36.00 36.00  The fee amount Keeps the value   $                          37.50  $      1.50  TRUE                  3 ATM_INQ 13Feb2017 15Dec2016    $              0.50      $                            0.50                      3 ATM_INQ 16Feb2017 18Dec2016    $              0.50      $                            1.00                      3 ATM_INQ 17Feb2017 19Dec2016    $              0.50      $                            1.50                      3 ATM_OD 21Feb2017 23Dec2016  $      (0.20)  $            38.00 38.00  The fee amount Keeps the value   $                          39.50  $      1.50  TRUE     Diego Diaz ... View more

Hi All-   I am, going to start with a little background.  I do have a dataset like the following :   Cust_ID TransactionID POST_DATE  FEE  123 321 2/28/2018   123 322 2/10/2018   123 323 2/2/2018   123 324 2/1/2018   123 325 11/27/2017   456 326 2/1/2018   987 327 3/5/2018   987 328 2/5/2018   987 329 1/5/2018   987 330 12/5/2017   987 331 11/6/2017   654 332 11/13/2017   654 333 2/28/2018   654 334 2/28/2018   654 335 2/26/2018   654 336 2/26/2018   654 337 2/23/2018   654 338 2/21/2018   654 339 2/21/2018   654 340 2/20/2018   654 341 2/20/2018       I would like to loop through this dataset and update the Flag column with a 1 depending on information obtained in the following condition by cust_id:   -No fee for up to three transactions per rolling 30-day period.   This would update the dataset to be the following :   Cust_ID TransactionID POST_DATE  FEE  123 321 2/28/2018 1 123 322 2/10/2018 0 123 323 2/2/2018 0 123 324 2/1/2018 0 123 325 11/27/2017 0 456 326 2/1/2018 0 987 327 3/5/2018 0 987 328 2/5/2018 0 987 329 1/5/2018 0 987 330 12/5/2017 0 987 331 11/6/2017 0 654 332 11/13/2017 0 654 333 2/28/2018 1 654 334 2/28/2018 1 654 335 2/26/2018 1 654 336 2/26/2018 1 654 337 2/23/2018 1 654 338 2/21/2018 1 654 339 2/21/2018 0 654 340 2/20/2018 0 654 341 2/20/2018 0     I have been trying to retain the current record value but i have not been able to do it. I have got the flag only validation the current record with the next record. There's tons of documentation online that sort of applies, but nothing specific enough and try as I might, I can't seem to work it out.  I've been tempted to export the data to a file, parse it using VB and then reimport, but that is horribly backwards and inefficient. Plus, I won't learn anything about SAS.   Any help would be greatly appreciated.   Thanks,   Diego ... View more