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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.