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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.