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. ... View more

HI, Is there a way to modify the keep statement to ensure all field names containing a certain text are output? For example, I have many different balance fields in a dataset which are not part of an array and I would like to keep all fields containing the text 'balance'. Thanks. ... View more