interest Caculations monthly

SASUser0001 — Tue, 14 Apr 2020 00:01:49 GMT

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;

Re: interest Caculations monthly

Reeza — Tue, 14 Apr 2020 00:33:49 GMT

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

https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n1lltvbis7ye1an1eryo4leh2mck.htm&docsetVersion=9.4&locale=en

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;

topic interest Caculations monthly in SAS Procedures

interest Caculations monthly

Re: interest Caculations monthly