Something like this? Note that you should use the numeric value for the dates to get an accurate selection. proc sql;
select t.vendor_id
, t.voucher_id
, t.INVOICE_ID
, t.gross_amt
, t.INVOICE_DT
from ps_voucher t join
(select vendor_id,invoice_id, pay_amt, count(*) as pay_cnt
from ps_voucher
where invoice_dt between '01APR2021'd and '31MAY2021'd
group by vendor_id, invoice_id, pay_amt
having count(*)>1) p
on t.vendor_id = p.vendor_id
and t.invoice_id = p.invoice_id
and t.gross_amt=p.pay_amt
;
quit;
... View more