proc sql;
CONNECT TO ORACLE AS ORADB (user=&NAME password=&pASS path=ExaODIN preserve_comments);
create table Prp as
select a.*,
CASE WHEN (B.prp_date) ^=. THEN 'Y' ELSE 'N' END AS PrP
from Abc a left join connection to ORADB
(select prp_id,prp_date,prpi_amount
from (select * from ods.promise
where prp_date >= '01APR2020' and prp_status <> 'C' )a
inner join
(select id, prpi_seq_no,sum(prPI_Amount) as prpi_amount from ods.table_C) c
on
a.prp_id=c.id
and
a.PrP_SEQ_NO = c.PrP_SEQ_NO
) b
on a.id= B.prp_id
and a.Date = datepart(b.prp_Date)
group by a.id
;
Disconnect from ORADB;
quit;
... View more
