topic Re: Balance between 3,6 and 12 month Dates in SAS Programming

Balance between 3,6 and 12 month Dates

Rhino84 — Mon, 21 Mar 2022 17:23:32 GMT

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

Invalid Subject Line

PaigeMiller — Mon, 21 Mar 2022 17:20:37 GMT

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.

Re: Invalid Subject Line

Rhino84 — Mon, 21 Mar 2022 17:21:46 GMT

YES. I want this for all accounts (each individual account)

Re: Balance between 3,6 and 12 month Dates

PaigeMiller — Mon, 21 Mar 2022 18:07:41 GMT

@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.