topic Loop query in SAS Programming

Loop query

aarathi — Fri, 05 Aug 2016 05:21:05 GMT

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.

Re: Loop query

Reeza — Fri, 05 Aug 2016 06:15:14 GMT

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-data-AKA-generate/ta-p/258712

Re: Loop query

aarathi — Fri, 05 Aug 2016 17:52:29 GMT

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