https://communities.sas.com/t5/SAS-Enterprise-Guide/number-of-days-between-dates-for-column-operations/m-p/679985#M36878 <PRE><CODE class=" language-sas">data have; input ID DATE :yymmdd10.; format date yymmdd10.; datalines; 100 2020-07-01 100 2020-07-08 100 2020-07-13 110 2020-06-25 110 2020-06-29 ; data want; set have; by ID; days = dif(date); if first.ID then days=.; run;</CODE></PRE> Fri, 28 Aug 2020 10:41:58 GMT PeterClemmensen 2020-08-28T10:41:58Z https://communities.sas.com/t5/SAS-Enterprise-Guide/number-of-days-between-dates-for-column-operations/m-p/679983#M36877 <P>Hello. I would like to calculate the number of days between dates but for column operations. I have the following data:</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE</P><P>100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-07-01</P><P>100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-07-08</P><P>100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-07-13</P><P>110&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-06-25</P><P>110&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-06-29</P><P>I'd like to achieve data like:</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DAYS</P><P>100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-07-01&nbsp; &nbsp; &nbsp; &nbsp; .</P><P>100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-07-08&nbsp; &nbsp; &nbsp; &nbsp; 7</P><P>100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-07-13&nbsp; &nbsp; &nbsp; &nbsp; 5</P><P>110&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-06-25&nbsp; &nbsp; &nbsp; &nbsp; .</P><P>110&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-06-29&nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>Can you help with solution?</P> Fri, 28 Aug 2020 10:30:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/number-of-days-between-dates-for-column-operations/m-p/679983#M36877 PatrykSAS 2020-08-28T10:30:20Z https://communities.sas.com/t5/SAS-Enterprise-Guide/number-of-days-between-dates-for-column-operations/m-p/679985#M36878 <PRE><CODE class=" language-sas">data have; input ID DATE :yymmdd10.; format date yymmdd10.; datalines; 100 2020-07-01 100 2020-07-08 100 2020-07-13 110 2020-06-25 110 2020-06-29 ; data want; set have; by ID; days = dif(date); if first.ID then days=.; run;</CODE></PRE> Fri, 28 Aug 2020 10:41:58 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/number-of-days-between-dates-for-column-operations/m-p/679985#M36878 PeterClemmensen 2020-08-28T10:41:58Z