https://communities.sas.com/t5/SAS-Programming/SAS-Loop-query/m-p/290618#M60149 <P>Sample data set attached. We want to adjust the principal loss &amp; interest loss amount from the available credit amount . if the credit amount is less than the principal loss &amp; int loss for a account , then we have to adjust in same for another account with the same cust id.</P> Wed, 10 Aug 2016 05:24:59 GMT aarathi 2016-08-10T05:24:59Z https://communities.sas.com/t5/SAS-Programming/SAS-Loop-query/m-p/290618#M60149 <P>Sample data set attached. We want to adjust the principal loss &amp; interest loss amount from the available credit amount . if the credit amount is less than the principal loss &amp; int loss for a account , then we have to adjust in same for another account with the same cust id.</P> Wed, 10 Aug 2016 05:24:59 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Loop-query/m-p/290618#M60149 aarathi 2016-08-10T05:24:59Z https://communities.sas.com/t5/SAS-Programming/SAS-Loop-query/m-p/290619#M60150 <P>Please post your example data as datalines in a data step. Nobody in his right mind will open a Excel file from the internet.</P> <P>And also supply "want" data to ilustrate your requirements.</P> Wed, 10 Aug 2016 05:30:03 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Loop-query/m-p/290619#M60150 Kurt_Bremser 2016-08-10T05:30:03Z