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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.