ERROR: An unexpected semicolon occurred in the %DO statement.

[kimdukes77]

Can anyone help with the above error when running this small section of code below?

%macro start;

%if &i_creative. = 1 %then %do

data &tmp_filelist.;

length filename $150;

run;

%end;

%else %if &i_creative. >1 %then %do

proc append base=&tmp_filelist. data=&tmp_filelist2. force;

run;

%end;

%mend start;

[Kurt_Bremser]

You are missing semicolons to end the macro %do statements:

%macro start;
%if &i_creative. = 1 %then %do;
data &tmp_filelist.;
length filename $150;
run;
%end;
%else %if &i_creative. >1 %then %do;
proc append base=&tmp_filelist. data=&tmp_filelist2. force;
run;
%end;
%mend start;

[data_null__ · Accepted solution]

You need to add a semicolon after the word

%DO;

In both lines where it appears.

[kimdukes77]

Ah yes of course - such a schoolgirl error.

Curse SAS with it's misleading error messages!

[Reeza]

Just a note that you don't need that piece of code.

PROC APPEND doesn't require the base data set to preexist, so you only need the last section.