data a;
input @1 ID $
@3 EffDate ddmmyy10.
@15 ExpDate ddmmyy10.;
format EffDate date9. ExpDate date9.;
datalines;
A 01/04/2008 01/08/2008
B 01/02/2008 01/07/2010
;
run;
data b(keep= id effdate expdate);
set a;
end=intnx('year',effdate,0,'e') ;
exp=expdate;
do while(end lt exp);
expdate=end;
output;
effdate=expdate+1;
end=intnx('year',effdate,0,'e');
end;
expdate=exp;
output;
run;
Ksharp
... View more
