interest Caculations monthly

[SASUser0001]

hi I am looking to calculate interest for 6 months. where interest is compounded monthly. I have try to use do loop something like this but it doesnt calculate for 6 months. it only give me interest for first month. help please. 

do i = 1 to 6;

balance=total_balance;

interest+(((balance*rate)/100)/365)*30;

bal_1=balance+Interest;

end;

[Reeza]

You probably want to add an OUTPUT statement to your loop.

https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n1lltvbis7ye1an1eryo4leh2mck.htm&doc...

do i = 1 to 6;
balance=total_balance;
interest+(((balance*rate)/100)/365)*30;
bal_1=balance+Interest;
output;
end;

If you want multiple variables with the different months you may want an array instead.

Here's a tutorial on using Arrays in SAS
https://stats.idre.ucla.edu/sas/seminars/sas-arrays/

---

@SASUser0001 wrote:

hi I am looking to calculate interest for 6 months. where interest is compounded monthly. I have try to use do loop something like this but it doesnt calculate for 6 months. it only give me interest for first month. help please. 

do i = 1 to 6;

balance=total_balance;

interest+(((balance*rate)/100)/365)*30;

bal_1=balance+Interest;

end;

---