Loop query

[aarathi]

 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. 

[Reeza]

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

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

[aarathi]

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