data have;
input var1 date : anydtdte7.;
format date monyy7.;
cards;
1.1 Feb2018
1.4 Mar2018
2.6 Apr2018
3.3 May2018
4.5 Jun2018
;
proc sql;
create table want as
select *,(select var1 from have having date=min(date)) as base
from have;
quit;
... View more
