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

SeandJ — Wed, 29 Apr 2015 14:13:18 GMT

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.

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

PaigeMiller — Wed, 29 Apr 2015 14:32:54 GMT

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.

topic Ignoring a step in a macro if a called dataset does not exist in SAS Programming

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

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