hi,
i have a table "search" with one or more obs (variables A-M)
i also have a huge table "Sasuser.Data1" which has 1 million obs (variables A-M and Variables O and P)
what i need to do is search my DATA1 table for the obs in "search" and IF there is a match for ALL variables (A-M), then return variables O and P.
is this possible?
what is have so far is:
Libname sasuser;
options nodate pageno=1 linesize=80 pagesize=40;
proce compare base=work.search compare = sasuser.data1 listequalvar;
??????
run;
... View more