DATA Step, Macro, Functions and more

Calculating time differences with character fields

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Calculating time differences with character fields

Dear All,

Sorry for the question - I did search the site and found a few bits but nothing that solved my problem (or maybe I'm just a bit slow.. :-)).

Essentially, I have two date/time fields in character format ($19) displayed as, for example, '2013-10-15T12:33'.  I want to find the time difference in minutes between the two fields, e.g., one field is '2013-10-15T12:33', the other is '2013-10-15T12:35' = difference of 2 minutes.  Any idea how to do this? I think part of the problem is that the variables are in char format and I can't seem to convert...

Any help is greatly appreciated Smiley Happy

Thanks!


Accepted Solutions
Solution
‎04-02-2014 10:20 AM
Super User
Super User
Posts: 6,502

Re: Calculating time differences with character fields

Use E8601DT informat.

data have ;

  ct1='2013-10-15T12:33' ;

  ct2='2013-10-15T12:35' ;

  t1 = input(ct1,e8601dt.);

  t2 = input(ct2,e8601dt.);

  format t1 t2 e8601dt. ;

  diff = (t2-t1) / 60 ;

  put (_all_) (=/);

run;

ct1=2013-10-15T12:33

ct2=2013-10-15T12:35

t1=2013-10-15T12:33:00

t2=2013-10-15T12:35:00

diff=2

View solution in original post


All Replies
Solution
‎04-02-2014 10:20 AM
Super User
Super User
Posts: 6,502

Re: Calculating time differences with character fields

Use E8601DT informat.

data have ;

  ct1='2013-10-15T12:33' ;

  ct2='2013-10-15T12:35' ;

  t1 = input(ct1,e8601dt.);

  t2 = input(ct2,e8601dt.);

  format t1 t2 e8601dt. ;

  diff = (t2-t1) / 60 ;

  put (_all_) (=/);

run;

ct1=2013-10-15T12:33

ct2=2013-10-15T12:35

t1=2013-10-15T12:33:00

t2=2013-10-15T12:35:00

diff=2

Occasional Contributor
Posts: 8

Re: Calculating time differences with character fields

Thanks Tom - perfect - I owe you one...Smiley Happy

☑ This topic is SOLVED.

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

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