topic difference between date in rows by id in SAS Programming https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693532#M211488 <P>Hello I want to make the difference between dates by id&nbsp;</P> <P>&nbsp;</P> <P>data diff;</P> <P>set JOINT;<BR />days_between = intck('days',Ann_date,lag(Ann_date));<BR />by number;<BR />run;</P> <P>this program give this&nbsp;</P> <TABLE width="338"> <TBODY> <TR> <TD width="64">Number</TD> <TD width="137">Ann_date</TD> <TD width="137">days_between</TD> </TR> <TR> <TD>21</TD> <TD>2008-11-12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21</TD> <TD>2011-03-29</TD> <TD>-867</TD> </TR> <TR> <TD>21</TD> <TD>2015-01-21</TD> <TD>-1394</TD> </TR> <TR> <TD>21</TD> <TD>2016-03-29</TD> <TD>-433</TD> </TR> <TR> <TD>24</TD> <TD>2003-05-06</TD> <TD>4711</TD> </TR> <TR> <TD>24</TD> <TD>2016-01-25</TD> <TD>-4647</TD> </TR> <TR> <TD>24</TD> <TD>2016-05-10</TD> <TD>-106</TD> </TR> <TR> <TD>26</TD> <TD>2014-08-11</TD> <TD>638</TD> </TR> <TR> <TD>46</TD> <TD>2009-01-19</TD> <TD>2030</TD> </TR> <TR> <TD>53</TD> <TD>2008-07-15</TD> <TD>188</TD> </TR> <TR> <TD>53</TD> <TD>2009-07-27</TD> <TD>-377</TD> </TR> <TR> <TD>53</TD> <TD>2010-06-11</TD> <TD>-319</TD> </TR> <TR> <TD>53</TD> <TD>2010-07-16</TD> <TD>-35</TD> </TR> <TR> <TD>53</TD> <TD>2015-01-15</TD> <TD>-1644</TD> </TR> <TR> <TD>53</TD> <TD>2015-10-09</TD> <TD>-267</TD> </TR> </TBODY> </TABLE> <P>I want&nbsp;</P> <P>&nbsp;</P> <TABLE width="338"> <TBODY> <TR> <TD width="64">Number</TD> <TD width="137">Ann_date</TD> <TD width="137">days_between</TD> </TR> <TR> <TD>21</TD> <TD>2008-11-12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21</TD> <TD>2011-03-29</TD> <TD>-867</TD> </TR> <TR> <TD>21</TD> <TD>2015-01-21</TD> <TD>-1394</TD> </TR> <TR> <TD>21</TD> <TD>2016-03-29</TD> <TD>-433</TD> </TR> <TR> <TD>24</TD> <TD>2003-05-06</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24</TD> <TD>2016-01-25</TD> <TD>-4647</TD> </TR> <TR> <TD>24</TD> <TD>2016-05-10</TD> <TD>-106</TD> </TR> <TR> <TD>26</TD> <TD>2014-08-11</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>46</TD> <TD>2009-01-19</TD> <TD>2030</TD> </TR> <TR> <TD>53</TD> <TD>2008-07-15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>53</TD> <TD>2009-07-27</TD> <TD>-377</TD> </TR> <TR> <TD>53</TD> <TD>2010-06-11</TD> <TD>-319</TD> </TR> <TR> <TD>53</TD> <TD>2010-07-16</TD> <TD>-35</TD> </TR> <TR> <TD>53</TD> <TD>2015-01-15</TD> <TD>-1644</TD> </TR> <TR> <TD>53</TD> <TD>2015-10-09</TD> <TD>-267</TD> </TR> </TBODY> </TABLE> Thu, 22 Oct 2020 15:09:17 GMT sasphd 2020-10-22T15:09:17Z difference between date in rows by id https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693532#M211488 <P>Hello I want to make the difference between dates by id&nbsp;</P> <P>&nbsp;</P> <P>data diff;</P> <P>set JOINT;<BR />days_between = intck('days',Ann_date,lag(Ann_date));<BR />by number;<BR />run;</P> <P>this program give this&nbsp;</P> <TABLE width="338"> <TBODY> <TR> <TD width="64">Number</TD> <TD width="137">Ann_date</TD> <TD width="137">days_between</TD> </TR> <TR> <TD>21</TD> <TD>2008-11-12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21</TD> <TD>2011-03-29</TD> <TD>-867</TD> </TR> <TR> <TD>21</TD> <TD>2015-01-21</TD> <TD>-1394</TD> </TR> <TR> <TD>21</TD> <TD>2016-03-29</TD> <TD>-433</TD> </TR> <TR> <TD>24</TD> <TD>2003-05-06</TD> <TD>4711</TD> </TR> <TR> <TD>24</TD> <TD>2016-01-25</TD> <TD>-4647</TD> </TR> <TR> <TD>24</TD> <TD>2016-05-10</TD> <TD>-106</TD> </TR> <TR> <TD>26</TD> <TD>2014-08-11</TD> <TD>638</TD> </TR> <TR> <TD>46</TD> <TD>2009-01-19</TD> <TD>2030</TD> </TR> <TR> <TD>53</TD> <TD>2008-07-15</TD> <TD>188</TD> </TR> <TR> <TD>53</TD> <TD>2009-07-27</TD> <TD>-377</TD> </TR> <TR> <TD>53</TD> <TD>2010-06-11</TD> <TD>-319</TD> </TR> <TR> <TD>53</TD> <TD>2010-07-16</TD> <TD>-35</TD> </TR> <TR> <TD>53</TD> <TD>2015-01-15</TD> <TD>-1644</TD> </TR> <TR> <TD>53</TD> <TD>2015-10-09</TD> <TD>-267</TD> </TR> </TBODY> </TABLE> <P>I want&nbsp;</P> <P>&nbsp;</P> <TABLE width="338"> <TBODY> <TR> <TD width="64">Number</TD> <TD width="137">Ann_date</TD> <TD width="137">days_between</TD> </TR> <TR> <TD>21</TD> <TD>2008-11-12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21</TD> <TD>2011-03-29</TD> <TD>-867</TD> </TR> <TR> <TD>21</TD> <TD>2015-01-21</TD> <TD>-1394</TD> </TR> <TR> <TD>21</TD> <TD>2016-03-29</TD> <TD>-433</TD> </TR> <TR> <TD>24</TD> <TD>2003-05-06</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24</TD> <TD>2016-01-25</TD> <TD>-4647</TD> </TR> <TR> <TD>24</TD> <TD>2016-05-10</TD> <TD>-106</TD> </TR> <TR> <TD>26</TD> <TD>2014-08-11</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>46</TD> <TD>2009-01-19</TD> <TD>2030</TD> </TR> <TR> <TD>53</TD> <TD>2008-07-15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>53</TD> <TD>2009-07-27</TD> <TD>-377</TD> </TR> <TR> <TD>53</TD> <TD>2010-06-11</TD> <TD>-319</TD> </TR> <TR> <TD>53</TD> <TD>2010-07-16</TD> <TD>-35</TD> </TR> <TR> <TD>53</TD> <TD>2015-01-15</TD> <TD>-1644</TD> </TR> <TR> <TD>53</TD> <TD>2015-10-09</TD> <TD>-267</TD> </TR> </TBODY> </TABLE> Thu, 22 Oct 2020 15:09:17 GMT https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693532#M211488 sasphd 2020-10-22T15:09:17Z Re: difference between date in rows by id https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693536#M211489 <P>Assuming 46 is a typo as there's only one record.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data diff; set JOINT; by Number; days_between = intck('days',Ann_date,lag(Ann_date)); if first.Number then call missing(days_between); run;</CODE></PRE> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/4327">@sasphd</a>&nbsp;wrote:<BR /> <P>Hello I want to make the difference between dates by id&nbsp;</P> <P>&nbsp;</P> <P>data diff;</P> <P>set JOINT;<BR />days_between = intck('days',Ann_date,lag(Ann_date));<BR />by number;<BR />run;</P> <P>this program give this&nbsp;</P> <TABLE width="338"> <TBODY> <TR> <TD width="64">Number</TD> <TD width="137">Ann_date</TD> <TD width="137">days_between</TD> </TR> <TR> <TD>21</TD> <TD>2008-11-12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21</TD> <TD>2011-03-29</TD> <TD>-867</TD> </TR> <TR> <TD>21</TD> <TD>2015-01-21</TD> <TD>-1394</TD> </TR> <TR> <TD>21</TD> <TD>2016-03-29</TD> <TD>-433</TD> </TR> <TR> <TD>24</TD> <TD>2003-05-06</TD> <TD>4711</TD> </TR> <TR> <TD>24</TD> <TD>2016-01-25</TD> <TD>-4647</TD> </TR> <TR> <TD>24</TD> <TD>2016-05-10</TD> <TD>-106</TD> </TR> <TR> <TD>26</TD> <TD>2014-08-11</TD> <TD>638</TD> </TR> <TR> <TD>46</TD> <TD>2009-01-19</TD> <TD>2030</TD> </TR> <TR> <TD>53</TD> <TD>2008-07-15</TD> <TD>188</TD> </TR> <TR> <TD>53</TD> <TD>2009-07-27</TD> <TD>-377</TD> </TR> <TR> <TD>53</TD> <TD>2010-06-11</TD> <TD>-319</TD> </TR> <TR> <TD>53</TD> <TD>2010-07-16</TD> <TD>-35</TD> </TR> <TR> <TD>53</TD> <TD>2015-01-15</TD> <TD>-1644</TD> </TR> <TR> <TD>53</TD> <TD>2015-10-09</TD> <TD>-267</TD> </TR> </TBODY> </TABLE> <P>I want&nbsp;</P> <P>&nbsp;</P> <TABLE width="338"> <TBODY> <TR> <TD width="64">Number</TD> <TD width="137">Ann_date</TD> <TD width="137">days_between</TD> </TR> <TR> <TD>21</TD> <TD>2008-11-12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21</TD> <TD>2011-03-29</TD> <TD>-867</TD> </TR> <TR> <TD>21</TD> <TD>2015-01-21</TD> <TD>-1394</TD> </TR> <TR> <TD>21</TD> <TD>2016-03-29</TD> <TD>-433</TD> </TR> <TR> <TD>24</TD> <TD>2003-05-06</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24</TD> <TD>2016-01-25</TD> <TD>-4647</TD> </TR> <TR> <TD>24</TD> <TD>2016-05-10</TD> <TD>-106</TD> </TR> <TR> <TD>26</TD> <TD>2014-08-11</TD> <TD>&nbsp;</TD> </TR> <TR> <TD><FONT color="#FF6600"><STRONG>46</STRONG></FONT></TD> <TD><FONT color="#FF6600"><STRONG>2009-01-19</STRONG></FONT></TD> <TD><FONT color="#FF6600"><STRONG>2030????</STRONG></FONT></TD> </TR> <TR> <TD>53</TD> <TD>2008-07-15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>53</TD> <TD>2009-07-27</TD> <TD>-377</TD> </TR> <TR> <TD>53</TD> <TD>2010-06-11</TD> <TD>-319</TD> </TR> <TR> <TD>53</TD> <TD>2010-07-16</TD> <TD>-35</TD> </TR> <TR> <TD>53</TD> <TD>2015-01-15</TD> <TD>-1644</TD> </TR> <TR> <TD>53</TD> <TD>2015-10-09</TD> <TD>-267</TD> </TR> </TBODY> </TABLE> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Thu, 22 Oct 2020 15:13:56 GMT https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693536#M211489 Reeza 2020-10-22T15:13:56Z Re: difference between date in rows by id https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693539#M211491 <P>yes it is a typo</P> <P>thanks</P> Thu, 22 Oct 2020 15:23:54 GMT https://communities.sas.com/t5/SAS-Programming/difference-between-date-in-rows-by-id/m-p/693539#M211491 sasphd 2020-10-22T15:23:54Z