topic Re: Do loop in SAS Programming

Do loop

parmis — Thu, 12 Jul 2018 16:00:41 GMT

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!

Re: Do loop

novinosrin — Thu, 12 Jul 2018 16:03:06 GMT

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;

Re: Do loop

Astounding — Thu, 12 Jul 2018 16:10:33 GMT

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.

Re: Do loop

parmis — Thu, 12 Jul 2018 16:15:39 GMT

I still get the same error

Re: Do loop

novinosrin — Thu, 12 Jul 2018 16:36:41 GMT

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

Re: Do loop

parmis — Thu, 12 Jul 2018 19:20:27 GMT

It works. Thank you so much