Desktop productivity for business analysts and programmers

Time Difference between Different Records

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 94
Accepted Solution

Time Difference between Different Records

Hello,

Below is resultant table with just the first and last records for each application.  How can I get the time difference between the first record (Start Time) and the last record (EndTime) for the same application id?

For example - AppID 1001 time difference is 0 hours, 2 minutes, 24 seconds.

Thanks!

AppIDOprIDStartTimeEndTime
1001109OCT2013:11:24:51.00000009OCT2013:11:27:15.000000
1001109OCT2013:11:26:16.00000009OCT2013:11:27:15.000000
1002209OCT2013:09:15:49.00000009OCT2013:09:34:33.000000
1002209OCT2013:09:24:16.00000009OCT2013:09:34:33.000000
1003309OCT2013:11:19:43.00000009OCT2013:11:19:57.000000
1003310OCT2013:14:50:47.00000010OCT2013:14:51:16.000000

Accepted Solutions
Solution
‎10-11-2013 04:27 PM
Regular Contributor
Posts: 244

Re: Time Difference between Different Records

DATETIMEs in SAS are stored as an integer number of seconds since 1/1/1960 0:00:00.  So, you can simply subtract the two values.  You can then format the result with a TIME format.

Data want;
set have;
by appID;
retain starting_time;
if first.appID then starting_time=starttime;
if last.appID then do;
duration=endtime-starting_time;
output;
end;
format duration TIME8.;
run;

View solution in original post


All Replies
Solution
‎10-11-2013 04:27 PM
Regular Contributor
Posts: 244

Re: Time Difference between Different Records

DATETIMEs in SAS are stored as an integer number of seconds since 1/1/1960 0:00:00.  So, you can simply subtract the two values.  You can then format the result with a TIME format.

Data want;
set have;
by appID;
retain starting_time;
if first.appID then starting_time=starttime;
if last.appID then do;
duration=endtime-starting_time;
output;
end;
format duration TIME8.;
run;
Frequent Contributor
Posts: 94

Re: Time Difference between Different Records

Thank you very much Snoopy369!

☑ This topic is SOLVED.

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

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