cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jogianni
‎03-20-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Calculate difference between two dates in the same column conditio...

by Calcite | Level 5 in SAS Procedures
‎03-20-2018 02:52 PM
‎03-20-2018 02:52 PM
thanks, though this doesn't reset at day I used it and used Astounding's if statement on there:     data want; format LAG DATETIME24.; set have; LAG=LAG(timestamp); by user date; if first.date then dif=0; else dif=intCK("Second",LAG,timestamp); run; ... View more

Calculate difference between two dates in the same column conditional ...

by Calcite | Level 5 in SAS Procedures
‎03-19-2018 07:16 PM
‎03-19-2018 07:16 PM
I have stacked user actions in a table and would like to calculate the number of seconds between each action for each user within that day. The issue is multiple users can access at once, so their actions are stacked, and I would like to only calculate that difference if the actions occurred on the same day.    example: data have:   id Timestamp User date 1390267 2/19/2018 20:01:33 Rick 2/19/2018 1390273 2/19/2018 20:02:36 Mike 2/19/2018 1390276 2/19/2018 20:03:15 Rick 2/19/2018 1390763 2/19/2018 22:33:49 Fred 2/19/2018 1390979 2/19/2018 22:54:18 Suzi 2/19/2018 1391119 2/19/2018 23:12:39 Fred 2/19/2018 1391124 2/19/2018 23:13:21 Fred 2/19/2018 1392279 2/20/2018 22:54:00 Suzi 2/20/2018 1391339 2/20/2018 23:12:00 Fred 2/20/2018     data want:   id Timestamp User date Dif 1390267 2/19/2018 20:01:33 Rick 2/19/2018 0 1390273 2/19/2018 20:02:36 Mike 2/19/2018 0 1390276 2/19/2018 20:03:15 Rick 2/19/2018 87 1390763 2/19/2018 22:33:49 Fred 2/19/2018 0 1390979 2/19/2018 22:54:18 Suzi 2/19/2018 0 1391119 2/19/2018 23:12:39 Fred 2/19/2018 2171 1391124 2/19/2018 23:13:21 Fred 2/19/2018 42 1392279 2/20/2018 22:54:00 Suzi 2/20/2018 0 1391339 2/20/2018 23:12:00 Fred 2/20/2018 0 ... View more

expand a dataset of dates to include all days within each range

by Calcite | Level 5 in SAS Programming
‎04-06-2016 12:45 PM
‎04-06-2016 12:45 PM
so I have a list of dates, and for merging purposes I would like to get all the days inbetween each one. example: current dateset: date 12/16/2016 12/23/2016 12/30/2016 01/06/2017 Desired Dataset: date days 12/16/2016 12/16/2016 12/16/2016 12/17/2016 12/16/2016 12/18/2016 12/16/2016 12/19/2016 12/16/2016 12/20/2016 12/16/2016 12/21/2016 12/16/2016 12/22/2016 12/23/2016 12/23/2016 12/23/2016 12/24/2016 12/23/2016 12/25/2016 12/23/2016 12/26/2016 12/23/2016 12/27/2016 12/23/2016 12/28/2016 12/23/2016 12/29/2016 12/30/2016 12/30/2016 12/30/2016 12/31/2016 12/30/2016 1/1/2017 12/30/2016 1/2/2017 12/30/2016 1/3/2017 12/30/2016 1/4/2017 12/30/2016 1/5/2017 Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-20-2018 05:03 PM
Quick links