topic Re: Macro error in New SAS User

Macro error

SamiBG — Sun, 16 Aug 2020 21:21:51 GMT

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;

Re: Macro error

PaigeMiller — Sun, 16 Aug 2020 21:33:47 GMT

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.

Re: Macro error

SamiBG — Sun, 16 Aug 2020 21:41:20 GMT

Hi PaigeMiller,

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