topic Re: do loop in SAS Programming

do loop

Ravikumarpa4 — Wed, 22 Feb 2017 12:37:24 GMT

need solution for below question by using do loop

each year an employee invests 5000 in an account determine the value of account after 3 year based on constant intrest rate of 4.5

Re: do loop

RW9 — Wed, 22 Feb 2017 12:42:06 GMT

Solution is to use SAS code. Realy what do you expect? You have provided nothing, where is the test data (in the form of a datastep), where is the example output. What code have you tried etc.

Re: do loop

art297 — Wed, 22 Feb 2017 14:51:16 GMT

There's a function for that: MORT (see: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245917.htm)

However, to use it, you'll have to specify whether the interest is compounded daily, monthly or whatever.

Art, CEO, AnalystFinder.com

Re: do loop

Ksharp — Thu, 23 Feb 2017 04:07:50 GMT

data _null_;
cum=0;
do n=0 to 2;
 cum=cum+1.045**n;
 
 total=5000*cum;
 year=n+1;
 put year= total= ;
end;
run;

Re: do loop

Ravikumarpa4 — Thu, 23 Feb 2017 05:54:28 GMT

thanks for your code. i got the what i'm expecting but need one clarification on how you deceided 'cum=cum+1.045**n;'

Re: do loop

Yavuz — Thu, 23 Feb 2017 06:18:48 GMT

Hi, your question is about to "compound interest calculation" which is calculated as c=c+(1+r)^n classical formula.
C is capital, r is interest rate, n is period.
Thanks for Ksharp's solution.

Re: do loop

Ravikumarpa4 — Thu, 23 Feb 2017 08:20:24 GMT

ok thanks but if want calcualte on simple interest then it will be 'cum=cum+1.045;' right?

Re: do loop

Ksharp — Thu, 23 Feb 2017 11:06:55 GMT

It is equivalent with:

1+1.045

1+1.045+1.045**2

Re: do loop

Yavuz — Thu, 23 Feb 2017 13:00:03 GMT

Yes, but
If your interest rate (0.045) for one month and want to calculate simple annual interest multiply by 12
Cum=cum+(1.045)*12