topic Loops: why do I get i+1 iterations instead of i ? in SAS Programming

Loops: why do I get i+1 iterations instead of i ?

deleted_user — Thu, 22 Oct 2009 15:37:28 GMT

Hi,
I submitted this code:

data MyTable;
do i=1 to 5;
end;
run;

and I got

Obs i
1 6.

I'm confused : Why do I get 6 and not 5 ??

Thank you in advance

Re: Loops: why do I get i+1 iterations instead of i ?

CurtisMack — Thu, 22 Oct 2009 15:42:49 GMT

Because the loop incremented the value of i until it was greater than 5 (6) and then the implied OUTPUT statement that occurs before the RUN statement executed.
I think you want this:
-----------------------------
data MyTable;
do i=1 to 5;
OUTPUT;
end;
run;
----------------------------
When you explicitly specify an OUTPUT statement, it overrides the implied OUTPUT statement that occurs before the RUN statement, so on the value of i that occured inside the loop are output;
Hope that was clear.

Re: Loops: why do I get i+1 iterations instead of i ?

deleted_user — Thu, 22 Oct 2009 17:30:02 GMT

Yes ok thank you 😉