data have; input Member AdmitDate : date9. DischargeDate : date9.; format AdmitDate DischargeDate : date9.; cards; 111 17MAY2017 17MAY2017 111 18MAY2017 18MAY2017 111 16MAY2017 24MAY2017 222 02JAN2016 05JAN2016 222 03JAN2016 04JAN2016 333 03MAR2017 04MAR2017 333 22FEB2017 09MAR2017 333 01JUL2017 01JUL2017 ; run; data temp; set have; do date=AdmitDate to DischargeDate; output; end; format date date9.; keep member date; run; proc sort data=temp nodupkey; by member date; run; data temp; set temp; by member; if first.member or dif(date) ne 1 then group+1; run; proc summary data=temp; by member group; var date; output out=want min=AdmitDate max=DischargeDate; run; ... View more

The same as PG's .   data have; input ID DOS :mmddyy. Category $; format dos mmddyy10.; datalines; 111 1/2/2015 PT/OT 111 1/3/2015 PT/OT 111 3/5/2016 Chiro 111 2/6/2017 PT/OT 222 5/6/2015 Chiro 222 7/8/2016 Chiro 222 8/10/2016 PT/OT 222 9/10/2016 Chiro 222 9/10/2017 PT/OT 222 10/11/2017 Chiro ; data want; set have; by id ; retain temp; if first.id then do;temp=dos;output;end; else if intnx('year',temp,1,'s')=<dos then do;temp=dos;output;end; drop temp; run; ... View more