DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

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

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.



Accepted Solutions
Solution
‎04-29-2015 10:32 AM
Trusted Advisor
Posts: 1,612

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

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.

View solution in original post


All Replies
Solution
‎04-29-2015 10:32 AM
Trusted Advisor
Posts: 1,612

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

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation