Date:         Tue, 7 Jun 2005 14:28:53 -0700
Reply-To:     nevin.krishna@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         nevin.krishna@GMAIL.COM
Organization: http://groups.google.com
Subject:      do loop conundrum
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

hello all,

I have the following example code. It calculates the takes the value of
a loan $100,000..and adds 5% interest to it each year for 30
years..thereby showing the amount of interest+the initial loan amount
over the entire time period.

data one;
        cap=200000;
        do yr=1 to 30;
                rate=.05*cap;
                cap+rate;
                output;
        end;
run;

What i would like to do now but can't seem to figure out how to is to
create another variable which shows how much the loan amount would
decrease by making monthly payments of $1500 ($18000 yearly) at the end
of 30 years (if not sooner) while factoring in the interest
accumulation ..

any suggestions greatly appreciated..

Thanks, nevin