DATA Step, Macro, Functions and more

how to find time interval between the datetime on the row and the previous row

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 134
Accepted Solution

how to find time interval between the datetime on the row and the previous row

Hi, I have a table that looks like this. (Sorted by City and then by Order Completion Time)

 

City Order No Order Completion Time Time between Order Processing (Mints)
Toronto 1 18APR2017:00:50:00.000  
Toronto 2 18APR2017:01:07:00.000 17
Toronto 3 18APR2017:01:50:00.000 43
Toronto 4 18APR2017:02:44:00.000 54
Toronto 5 18APR2017:03:15:00.000 31
Toronto 6 18APR2017:03:55:00.000 40

 

 

Now I want to calculate  "Time Between Order Processing" which is simply the time of the order minus time of the previous order.

 

can you please advise how to do it


Accepted Solutions
Solution
‎09-20-2017 02:14 PM
Super User
Posts: 22,875

Re: how to find time interval between the datetime on the row and the previous row

Look up the LAG or DIF functions. 

View solution in original post


All Replies
Solution
‎09-20-2017 02:14 PM
Super User
Posts: 22,875

Re: how to find time interval between the datetime on the row and the previous row

Look up the LAG or DIF functions. 

Frequent Contributor
Posts: 134

Re: how to find time interval between the datetime on the row and the previous row

Thank you
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 75 views
  • 0 likes
  • 2 in conversation