topic Re: how to find time interval between the datetime on the row and the previous row in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/396957#M95899 <P>Look up the LAG or DIF functions.&nbsp;</P> Mon, 18 Sep 2017 20:39:41 GMT Reeza 2017-09-18T20:39:41Z how to find time interval between the datetime on the row and the previous row https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/396956#M95898 <P>Hi, I have a table that looks like this. (Sorted by City and then by Order Completion Time)</P> <P>&nbsp;</P> <TABLE width="494"> <TBODY> <TR> <TD width="64">City</TD> <TD width="64">Order No</TD> <TD width="156">Order Completion Time</TD> <TD width="210"><STRONG>Time between Order Processing (Mints)</STRONG></TD> </TR> <TR> <TD>Toronto</TD> <TD>1</TD> <TD>18APR2017:00:50:00.000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>Toronto</TD> <TD>2</TD> <TD>18APR2017:01:07:00.000</TD> <TD><STRONG>17</STRONG></TD> </TR> <TR> <TD>Toronto</TD> <TD>3</TD> <TD>18APR2017:01:50:00.000</TD> <TD><STRONG>43</STRONG></TD> </TR> <TR> <TD>Toronto</TD> <TD>4</TD> <TD>18APR2017:02:44:00.000</TD> <TD><STRONG>54</STRONG></TD> </TR> <TR> <TD>Toronto</TD> <TD>5</TD> <TD>18APR2017:03:15:00.000</TD> <TD><STRONG>31</STRONG></TD> </TR> <TR> <TD>Toronto</TD> <TD>6</TD> <TD>18APR2017:03:55:00.000</TD> <TD><STRONG>40</STRONG></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>Now I want to calculate &nbsp;"Time Between Order Processing" which is simply the time of the order minus time of the previous order.</P> <P>&nbsp;</P> <P>can you please advise how to do it</P> Mon, 18 Sep 2017 20:36:33 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/396956#M95898 tparvaiz 2017-09-18T20:36:33Z Re: how to find time interval between the datetime on the row and the previous row https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/396957#M95899 <P>Look up the LAG or DIF functions.&nbsp;</P> Mon, 18 Sep 2017 20:39:41 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/396957#M95899 Reeza 2017-09-18T20:39:41Z Re: how to find time interval between the datetime on the row and the previous row https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/397560#M96091 Thank you Wed, 20 Sep 2017 18:14:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-time-interval-between-the-datetime-on-the-row-and/m-p/397560#M96091 tparvaiz 2017-09-20T18:14:51Z