how to compare a charactor datetime with a numeric datetime.

[tony7zx]

I have two variables in this dateset.

column A                               column B

2016-12-09T09:45                 22NOV2016:00:50:07

column A is charactor variable. column B is numeric.

Each variable I have about 200 obs.

I need to not only consider the date, but also the time.

For some obs, that have same date, so I also need to compare time.

[Kurt_Bremser · Accepted solution]

There are ISO-formats for this type of date and datetime notation:

data have;
input col_a :$16. col_b :datetime19.;
format col_b datetime19.;
cards;
2016-12-09T09:45 22NOV2016:00:50:07
;
run;

data want;
set have;
col_a_num = input(col_a,e8601dt19.);
format col_a_num datetime19.;
run;

[tony7zx]

Thank you so much! It is working. I was try to find the right input format for a long time.



Thank you. Great answer!