libname new "/dmenv/dmwork/gsk2118436/brf113928/test/raw/FROM_FSP/Transfer_20190916/BRF113928_ToNovartis_20190916/new"; libname old "/dmenv/dmwork/gsk2118436/brf113928/test/raw/FROM_FSP/Transfer_20190910/BRF113928_ToNovartis_20190910/old"; proc sql; select distinct memname into:macvar separated by ' ' from sashelp.vstable where upcase(libname)="NEW" ; quit; %put &macvar; %macro test; %local i; %do i= 1 %to &sqlobs; %let dst=%scan(&macvar,&i,' '); Proc Compare Base = new.&dst Compare = old.&dst/*Outbase OutComp Outdiff Outnoequal*/listall Out = Dm_Diff_comp ; Run; %end; %mend; %put &dst ; %test;
... View more
