Okay...so you need to do the oracle stuff all together and then join the results to a.
proc sql;
CONNECT TO ORACLE (user=&name pw=&pass path=Exa);
create table P_1 as
select p1.*,a.* from connection to oracle
(select ID,SEQ_NO,Tableb_DATE,trunc(tableb_Date) as p1date,AMT
from p_act
) p1
left join a on p1.id=a.id and a.id_date > p1date
;
disconnect from oracle;
quit;
... View more
