topic Re: How to do math in a loop body? in New SAS User

How to do math in a loop body?

muskagap — Wed, 16 Oct 2019 21:29:00 GMT

Hello, first off - I'm a begginer, please take it into account;)

My problem is that I can't do simple math within loop body. I need to calculate interest capitalization after 5 years. Starting amount is 5000 USD.

data xyz.Capit;

amount = 5000;

i=1;

do while (i <= 5);

i + 1;

option1 = amount*(1,04/1);

end;

run;

This code can't be executed, shows errors (sth about aritmethical error). What's wrong with it?

Re: How to do math in a loop body?

Reeza — Wed, 16 Oct 2019 21:33:24 GMT

What does the log show as errors?

Please include the log.

@muskagap wrote:

Hello, first off - I'm a begginer, please take it into account;)

My problem is that I can't do simple math within loop body. I need to calculate interest capitalization after 5 years. Starting amount is 5000 USD.

data xyz.Capit;

amount = 5000;

i=1;

do while (i <= 5);

i + 1;

option1 = amount*(1,04/1);

end;

run;

This code can't be executed, shows errors (sth about aritmethical error). What's wrong with it?

Re: How to do math in a loop body?

muskagap — Wed, 16 Oct 2019 21:34:36 GMT

ERROR 388-185: Expecting an arithmetic operator.

ERROR 200-322: The symbol is not recognized and will be ignored.

Re: How to do math in a loop body?

novinosrin — Wed, 16 Oct 2019 21:34:57 GMT

Hi @muskagap Are you after this formula and result by any chance?

data Capit;

amount = 5000;

i=1;
do while (i <= 5);
amount = amount*(1.04/1);
output;
i + 1;
end;

run;

proc print noobs;run;

RESULT:

amount	i
5200.00	1
5408.00	2
5624.32	3
5849.29	4
6083.26	5

Re: How to do math in a loop body?

VDD — Wed, 16 Oct 2019 21:35:29 GMT

@muskagap you have a comma rather than a dot.

try this

data xyz.Capit;
amount = 5000;
i=1;
 
do while (i <= 5);
i + 1;
option1 = amount*(1.04/1);
end;

run;

Re: How to do math in a loop body?

Reeza — Wed, 16 Oct 2019 21:38:42 GMT

So the errors also indicate where exactly the issue is in the full log. Because you just posted the error I can't tell which part of the code it relates to.

Assuming you're not using a French or different version of SAS, the comma issue noted may be the overall issue.

Is the error at that location in the code?

Re: How to do math in a loop body?

muskagap — Wed, 16 Oct 2019 21:42:31 GMT

yes, that helped:) comma!

thanks!

Re: How to do math in a loop body?

ballardw — Thu, 17 Oct 2019 16:05:51 GMT

You may also want to investigate the SAS Finance function. The function has options to do a number of standard financial calculations such as accrued interest, interest paid between dates, more than 30 such calculations are available from the Finance function. Plus there are about another 30 functions for financial calculations.