topic Re: How to collapse records with consecutive dates in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-collapse-records-with-consecutive-dates/m-p/618953#M35415 <P>A couple of questions:</P> <P>&nbsp;</P> <UL> <LI>does subject play any role in the calculations or analysis? If so, how?</LI> <LI><SPAN>can start date and end date be different?</SPAN></LI> </UL> <P><SPAN>If you answer YES to any of these, can you provide a more realistic example of the data?</SPAN></P> <P><SPAN><BR />Also:&nbsp;</SPAN>when you say "<SPAN>Because the date is not a consecutive date" what date are you referring to, start date or enddate?&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN>Also: can you please provide working SAS code to read in your example data into a SAS data set?</SPAN></P> Tue, 21 Jan 2020 21:06:15 GMT PaigeMiller 2020-01-21T21:06:15Z How to collapse records with consecutive dates https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-collapse-records-with-consecutive-dates/m-p/618917#M35414 I have records as follows:<BR /><BR />Subject startdt. enddt dur<BR />01 01jan2019 01jan2019 1<BR />01 02jan2019 02jan2019 1<BR />01 03jan2019 03jan2019 1<BR />01 05jan2019 05jan2019 1<BR /><BR />I want the records with consecutive dates, that is from 1jan to 3jan be collapsed as 1 record and the dur value should be 3. Also the 5jan record should be left as is Because the date is not a consecutive date. Tue, 21 Jan 2020 18:22:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-collapse-records-with-consecutive-dates/m-p/618917#M35414 nisha_a 2020-01-21T18:22:44Z Re: How to collapse records with consecutive dates https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-collapse-records-with-consecutive-dates/m-p/618953#M35415 <P>A couple of questions:</P> <P>&nbsp;</P> <UL> <LI>does subject play any role in the calculations or analysis? If so, how?</LI> <LI><SPAN>can start date and end date be different?</SPAN></LI> </UL> <P><SPAN>If you answer YES to any of these, can you provide a more realistic example of the data?</SPAN></P> <P><SPAN><BR />Also:&nbsp;</SPAN>when you say "<SPAN>Because the date is not a consecutive date" what date are you referring to, start date or enddate?&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN>Also: can you please provide working SAS code to read in your example data into a SAS data set?</SPAN></P> Tue, 21 Jan 2020 21:06:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-collapse-records-with-consecutive-dates/m-p/618953#M35415 PaigeMiller 2020-01-21T21:06:15Z