topic Re: Time Difference between Different Records in SAS Enterprise Guide

Time Difference between Different Records

jen123 — Fri, 11 Oct 2013 20:11:44 GMT

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!

AppID	OprID	StartTime	EndTime
1001	1	09OCT2013:11:24:51.000000	09OCT2013:11:27:15.000000
1001	1	09OCT2013:11:26:16.000000	09OCT2013:11:27:15.000000
1002	2	09OCT2013:09:15:49.000000	09OCT2013:09:34:33.000000
1002	2	09OCT2013:09:24:16.000000	09OCT2013:09:34:33.000000
1003	3	09OCT2013:11:19:43.000000	09OCT2013:11:19:57.000000
1003	3	10OCT2013:14:50:47.000000	10OCT2013:14:51:16.000000

Re: Time Difference between Different Records

snoopy369 — Fri, 11 Oct 2013 20:27:29 GMT

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;

Re: Time Difference between Different Records

jen123 — Fri, 11 Oct 2013 20:40:34 GMT

Thank you very much Snoopy369!