Do loop

[parmis]

Hi,

I'm trying to do a do loop with proc sql. The following part of the script gives an error message:

%let totalobs = 100;

%let totalobs = &totalobs. + 1;

%put totalobs;

ERROR: Open code statement recursion detected.

Does anyone know what the issue is?

Thank you!

[novinosrin · Accepted solution]

Your code works fine

%let totalobs = 100;

%let totalobs = &totalobs. + 1;

%put totalobs=&totalobs;

/*or*/

%let totalobs = 100;

%let totalobs = %eval(&totalobs. + 1);

%put totalobs=&totalobs;

[parmis]

I still get the same error

[novinosrin]

Try to restart SAS and rerun

Here is my log:

1840 %let totalobs = 100;
1841
1842 %let totalobs = &totalobs. + 1;
1843
1844 %put totalobs=&totalobs;
totalobs=100 + 1
1845
1846
1847 /*or*/
1848
1849 %let totalobs = 100;
1850
1851 %let totalobs = %eval(&totalobs. + 1);
1852
1853 %put totalobs=&totalobs;
totalobs=101

[parmis]

It works. Thank you so much

[Astounding]

You might get that message if you made the mistake of omitting the first semicolon at the end of the first %LET statement.  If that's not the cause, we might need to see the log including the SQL piece.