topic Do loop index variable - output sometimes other times not in SAS Procedures

Do loop index variable - output sometimes other times not

Nyioves — Thu, 25 Jun 2015 20:10:16 GMT

Eg 1.

data compound;

Amount=50000;

Rate1=.075;

Yearly=Amount*Rate1;

do i=1 to 12;

Monthly+((Monthly+Amount)*(Rate1/12);

end;

run;

proc print data=compound; run;

output:

O Amt Rate1 Yrly Mnthly

1	50000	0.075	3750	1261.77

Why isn't I = 13 in the output?

Eg 2.

Here yearly does in fact show in the output and is incremented +1 _n_ ....

data invest;

Capital=0;

do Year=2001 to 2003;

Capital=5000;

Capital+(Capital*.075);

end;

run;

proc print data = invest; run;

Output:

O Cap Yr

1	5375	2004

Tom — Thu, 25 Jun 2015 20:22:14 GMT

Because the typo in the first data step makes it not run. So it didn't overwrite the previous version of the data set named COMPOUND.

1244 Monthly+((Monthly+Amount)*(Rate1/12);

ERROR 79-322: Expecting a ).

Nyioves — Fri, 26 Jun 2015 17:16:33 GMT

That is correct.

ballardw — Fri, 26 Jun 2015 19:33:10 GMT

BTW you may want to investigate financial functions in the SAS help. They can save a lot of coding for common calculations.