08-05-2016 01:21 AM
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.
08-05-2016 02:12 AM - edited 08-05-2016 02:15 AM
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
08-05-2016 01:52 PM
Sample data set ;
|Loan No||Relationship Id||Principal loss||Interest Loss||Available Amount|
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.