topic how to compare a charactor datetime with a numeric datetime. in SAS Programming

how to compare a charactor datetime with a numeric datetime.

tony7zx — Wed, 28 Jun 2017 12:59:14 GMT

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.

Re: how to compare a charactor datetime with a numeric datetime.

Kurt_Bremser — Wed, 28 Jun 2017 13:06:55 GMT

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;

Re: how to compare a charactor datetime with a numeric datetime.

tony7zx — Wed, 28 Jun 2017 13:12:04 GMT

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

Thank you. Great answer!