topic Re: datetime20. in SAS Programming

datetime20.

arpit — Wed, 22 Dec 2010 16:36:32 GMT

I have a data set which is like below

startdatetime enddatetime
12/11/201010:20:30 12/11/201013:20:40
29/12/201010:30:30 30/12/201015:20:40
14/10/201008:40:20 14/10/201017:30:49

now I want difference between startdatetime and enddatetime .
Thanks in advance.

Re: datetime20.

Peter_C — Wed, 22 Dec 2010 16:44:11 GMT

how about
duration = enddatetime - startdatetime ;
the result is in seconds

Re: datetime20.

polingjw — Wed, 22 Dec 2010 16:45:26 GMT

How do you want the result to be formatted?

Re: datetime20.

arpit — Wed, 22 Dec 2010 18:16:25 GMT

this is not working

I want in time10. format

Re: datetime20.

sbb — Wed, 22 Dec 2010 18:41:51 GMT

Possibly, you want to assign a SAS FORMAT statement to the "duration" variable/column result.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

format statement time site:sas.com

Re: datetime20.

arpit — Wed, 22 Dec 2010 18:44:38 GMT

go through google but i could not find .

Please help me I am trying so many time but i can't get it

Thanks in advance

Re: datetime20.

ArtC — Wed, 22 Dec 2010 18:47:58 GMT

What exactly is not working? When you apply Peter's solution, what error are you getting? Are your two datetime variables correctly holding SAS datetime values?

Re: datetime20.

Cynthia_sas — Wed, 22 Dec 2010 20:00:44 GMT

Hi:
Have you tried using the TIME format with your calculated duration???

Are you certain that all your durations are going to "fit" in TIME10?? What if your duration is more than 9999 hours??? More than 2 years (which is approx 17,000 hours)??

cynthia

Re: datetime20.

SPR — Wed, 22 Dec 2010 20:01:13 GMT

Hello Arpit,

I did the following code and got expected result (I only add a blank in input data separating date and time part):
[pre]
data i;
input s anydtdtm19. e anydtdtm19.;
format s e datetime20. dur time8.;
dur=e-s;
datalines;
12/11/2010 10:20:30 12/11/2010 13:20:40
29/12/2010 10:30:30 30/12/2010 15:20:40
14/10/2010 08:40:20 14/10/2010 17:30:49
;
run;
Dataset i:
s e dur
11DEC2010:10:20:30 11DEC2010:13:20:04 2:59:34
29DEC2010:10:30:30 30DEC2010:15:20:04 28:49:34
14OCT2010:08:40:20 14OCT2010:17:30:04 8:49:44
[/pre]
Sincerely,
SPR