Macro error

[SamiBG]

Hi community,

I am trying to find the error in the following Macro but I am not sure I got. Any thoughts?

Thanks in advance 🙂

%MACRO Cleanup;

   %IF &syserr <= 0 %THEN

          DO;

                proc sql;

                       drop table W.BASE;

                quit;

          END;

%MEND Cleanup;

[PaigeMiller · Accepted solution]

I see two errors, there may be more. It should be

%MACRO Cleanup;
   %IF &syserr <= 0 %THEN %DO;
                proc sql;
                       drop table W.BASE;
                quit;
    %END;
%MEND Cleanup;

If there are still errors, use the command

options mprint;

at the start of the program and show us the entire LOG for this macro (do not chop anything out of the LOG). Please preserve the formatting of the log by copying it as text and then pasting it into the window that appears when you click on the </> icon. DO NOT SKIP THIS STEP.

[SamiBG]

Hi PaigeMiller,

Thanks alot for the quick answer. That was what I was looking for 🙂