是不是这个意思:
proc sql;
create table c as
select a.*, b.date as b_date,b.othervar
from a left join b
on a.date>=b.date
group by a.date,a.othervar
having b.date=max(b.date)
;
quit;
是不是这个意思:
proc sql;
create table c as
select a.*, b.date as b_date,b.othervar
from a left join b
on a.date>=b.date
group by a.date,a.othervar
having b.date=max(b.date)
;
quit;