That works, thanks! Using your code, I added the time as well to the having condition: proc sql;
create table want as
select
t1.cusip,
intnx('month',t1.trd_exctn_dt,0,'b') as month format=yymmd7.,
trd_exctn_tm,
rptd_pr
from work.transactions t1
group by t1.cusip, calculated month
having t1.trd_exctn_dt = max(t1.trd_exctn_dt) and trd_exctn_tm = max(trd_exctn_tm)
;
quit; and was able to get what I was looking for. Thanks again!
... View more
