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;
