Good point. I have modified. data person; infile cards4 dsd firstobs=2; input person earning date :mmddyy.; format date mmddyy.; cards; Person,Earning,Date 1,12,1/23/2001 1,34,2/3/2001 1,23,2/25/2001 2,45,3/4/2001 2,32,3/27/2001 3,7,4/4/2001 3,34,5/5/2001 3,65,5/26/2001 3,33,6/6/2001 3,23,7/2/2001 4,33,2/3/2001 4,12,3/5/2001 ;;;; run; proc print; run; proc summary data=person nway; class person; output out=summary(drop=_:) sum(earning)=earning min(date)=min range(date)=period idgroup(max(date) out(date earning)=max lastearning); format period: ; run; proc print; run;
... View more