data have;
input Name $ Date:date9.;
format date date9.;
datalines;
Ben 31Dec2013
Ben 31Jan2014
Ben 31Mar2014
Ben 30Apr2014
Ben 30Jun2014
Ken 31Mar2014
Ken 31May2014
;
run;
data want;
merge have have(rename=(name=_name date=_date) firstobs=2);
if name=_name then do;
do i=1 to intck('month',intnx('month',date,0),intnx('month',_date,0)-1);
want_date=intnx('month',date,i);output;
end;
end;
format want_date date9.;
keep name want_date;
run;
... View more