consider the given table:
ACC | OPEN_DT | BAL | 3m_new_bal | 6m_new_bal | 12_new_bal |
10 | 12-Jan-20 | 10 | |||
11 | 14-Mar-20 | 23 | |||
12 | 16-Jun-21 | 10 | |||
13 | 9-May-15 | 21 | |||
14 | 7-Oct-19 | 10 | |||
15 | 20-Apr-18 | 67 | |||
16 | 23-Dec-96 | 10 | |||
17 | 12-Jan-83 | 54 |
I want to construct a new table that has 3 new columns (Blank columns shows above) which holds the sum of BAL between the range open_date and 3 months after open date, 6 months after open date and 12 months after open date
Do you want to do this by account (ACC)? Or across all accounts? I am not understanding this part. Could you explain in more detail.
Also, for this simple example, it would help if you could fill in the cells of the desired output table.
Finally, please go back to your original post and change the subject line to something meaningful that describes the problem. Every question here could have a subject line of "Need Help", but that's not acceptable really.
YES. I want this for all accounts (each individual account)
@Rhino84 wrote:
YES. I want this for all accounts (each individual account)
Okay, but then don't we need more data for each individual account? Please show us data that corresponds to this explanation.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.