We have a data set wih Account no, customer id, Total Principal Loss, Total Interest Loss , Credit amount available - total custid wise. for example One customer id will have multiple Loan accounts. We have to adjust the credit amount available to each loan account towards principal loss first & then towards interest loss.
Please post sample data, what you have and what you want. PLEASE no images. Include it as text or preferably a data step that we can read directly into SAS.
Edit: Here's a link on how to provide data
Sample data set ;
Loan No | Relationship Id | Principal loss | Interest Loss | Available Amount |
001 | a1 | 1250 | 300 | 6000 |
002 | a1 | 200 | ||
003 | a1 | 450 | ||
456 | a2 | 2000 | 450 | |
789 | a2 | 3000 | 390 | |
786 | a3 | 5000 | 850 | 4500 |
456 | a4 | 1200 | 650 | 3000 |
253 | a4 | 1300 | 753 | |
243 | a4 | 1900 | 253 | |
For each loan account we have to adjust the pricipal loss amount first & then Interest Loss from the available amount . Logic is for one relationship id there may many loan account nos as well as savings account nos. we have taken the available amount from the savings a/c. now we have to adjust the principal loss & interest loss for each loan account and to updated the balance due.
Regards
Aarthi
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.