@SWEETSAS wrote:
Thanks!@ballardw.
If the dataset were the same name in both libraries, this can be done with something like this:
do i=1 to &n;
proc compare
base=MYLIB1.&ds&i
compare=MYLIB2.&ds&i
out=MYLIB3.&ds&i
run;
end;
You can't run a Procedure within a SAS datastep so your code would not work. You could though achieve what you want to do by having the Proc Compare in a macro and then use call execute() within a do loop.
If the potential difference between DS names is only the V_ then it wouldn't be hard to create a list of the DS to be compared by querying dictionary.tables BUT: The V_... is often a naming convention for Views. Are you 100% sure these v_have1 "tables" are not just views of the have1 tables? If so a Proc Compare wouldn't make any sense for such cases.
Here some sample code how this could look like. Amend as required for your actual use case.
options dlcreatedir;
libname lib1 "%sysfunc(pathname(work))\lib1";
libname lib2 "%sysfunc(pathname(work))\lib2";
data lib1.want1 lib1.want2 lib1.want3;
set sashelp.class;
run;
data lib2.want1;
set lib1.want1;
run;
data lib2.v_want2;
set lib1.want1;
if _n_=5 then call missing(sex);
run;
proc sql;
create view lib2.v_want3 as
select * from lib1.want3
;
quit;
proc sql;
create table comp_tables as
select
l.libname as lib1,
l.memname as ds1,
r.libname as lib2,
r.memname as ds2
from
dictionary.tables l
inner join
dictionary.tables r
on
l.libname='LIB1' and r.libname='LIB2'
and l.memtype='DATA' and r.memtype='DATA'
and
(
l.memname=r.memname
or
substrn(r.memname,1,2)='V_' and l.memname=substrn(r.memname,3)
)
;
quit;
%macro compare(lib1,ds1,lib2,ds2);
proc compare data=&lib1..&ds1 comp=&lib2..&ds2;
run;
%mend;
data _null_;
set comp_tables;
length cmd $100;
cmd=cats( '%compare(',catx(',',lib1,ds1,lib2,ds2),')' );
call execute(cmd);
run;
