topic the last item in my loop was not executed in SAS Programming

the last item in my loop was not executed

fengyuwuzu — Thu, 02 Jun 2016 19:04:38 GMT

I have a number of variables that were log transformed, and I wanted to use these new variables to do ANOVA.

I first created a macro variable to store all the log transformed variables names and then used a do loop to repeat the anova analysis.

The problem is, my last log variables was not included in the anova analysis. I checked the values of the macro variables "collist" and "n", which were both correct.

What could be the problem?


%macro loop_var(data);
proc contents data=&data short out=test; run;
proc sql;
select name into :collist separated by ' '
from test
where name like 'log_%';
%let n=&sqlobs;
quit;
ods graphics off;
%do i=1 %to &n;
    %let currentvar=%scan(&collist,&i);
proc glm data=&data ;
class type;
model &currentvar=type;
lsmeans type /pdiff stderr cl ADJUST=SCHEFFE;
%end;
%mend;

%loop_var(mydata);

Re: the last item in my loop was not executed

Quentin — Thu, 02 Jun 2016 19:14:00 GMT

What values do you have for collist and n?

Perhaps add:

%put collist=&collist i=&i currentvar=&currentvar n=&n;

Immediately before your PROC GLM statement. That should help debug.

Re: the last item in my loop was not executed

ballardw — Thu, 02 Jun 2016 19:26:13 GMT

Try adding

run;

at the end of the Proc Glm code. You may not be running into a "boundary" to tell the procedure that the last one ended.

Re: the last item in my loop was not executed

fengyuwuzu — Thu, 02 Jun 2016 20:20:10 GMT

yes. this solved the problem. Thank you.