/*Here is an example you can start with*/
%let before= D:\XiaKeShan\sas_file_WM- ETcath200_Datasets_2023_05_15 09_05_50 ; *the path for yesterday dataset;
%let after= D:\XiaKeShan\sas_file_WM- ETbox200_Datasets_2023_05_15 09_05_17 ; *the path for today dataset;
libname before v9 "&before.";
libname after v9 "&after.";
%macro compare_dsn(first=,second= , output=);
proc sql;
create table &output. as
select * from &second.
except
select * from &first.
;
quit;
%mend;
proc datasets library=work kill memtype=data nolist nodetails;
quit;
data _null_;
set sashelp.vtable(keep=memname libname where=(libname='AFTER'));
call execute(catt('%compare_dsn(first=before.',memname,',second=after.',memname,', output=',memname,')'));
run;
proc sql;
select memname label='Table Name',ifc(nlobs=0,'equal ','not equal') as equal label='isEqual'
from dictionary.tables
where libname='WORK' ;
quit;
... View more