Ignoring a step in a macro if a called dataset does not exist

[SeandJ]

Hi,

I am running a macro for numerous dates which contains the following step.

%macro dataset1 (date);

proc sql;

create table libname.t3_&date.

as select a.*, b.balance

from  libname.t1_&date. a

left join libname.t2_&date. b on a.acc_no = b.acc_no;

quit;

%mend

Although the macro works and the desired output is achieved, there are instances where libname.t2_&date. does not exist (although libname.t1_&date. does). Is there a way of ignoring this step when libname.t2_&date does not exist to ensure there is no error in the log?

Thanks.

[PaigeMiller · Accepted solution]

In your macro, before PROC SQL

%if %sysfunc(exist(libname.t2_&date)) %then %do;

and of course you will need %end; after the quit; statement.