topic Re: Character to numeric conversion of datetime in SAS Programming

Character to numeric conversion of datetime

chinna0369 — Tue, 11 Aug 2020 16:11:21 GMT

Hi all,

I have data like below:

data data;
input date $20.;
cards;
2019-11-16
2020-04-09T09:40
2020-04-09T13:30
2020-04-10T11:05
2020-05-07T11:00
2020-05-07T11:08
2020-05-08T11:05
2020-06-04T10:05
2020-06-04T11:22
2020-06-05
2020-07-02T10:41
2020-07-02T10:50
;
run;

I would like to change those dates to numeric format of datetime19. and if missing time then I want to show 00:00:00. Can anyone suggest which format can use here?

I am using anydtdtm. but it's not wokring.

Thanks,

Adithya

Re: Character to numeric conversion of datetime

Reeza — Tue, 11 Aug 2020 16:13:12 GMT

Show your code that doesn't work please.

Re: Character to numeric conversion of datetime

PaigeMiller — Tue, 11 Aug 2020 16:21:06 GMT

data data;
input date b8601dt.;
format date datetime16.;
cards;
2019-11-16
2020-04-09T09:40
2020-04-09T13:30
2020-04-10T11:05
2020-05-07T11:00
2020-05-07T11:08
2020-05-08T11:05
2020-06-04T10:05
2020-06-04T11:22
2020-06-05
2020-07-02T10:41
2020-07-02T10:50
;
run;

Re: Character to numeric conversion of datetime

chinna0369 — Tue, 11 Aug 2020 16:21:51 GMT

I am using below code and not getting value for all records:
data want;
set data;
want_date=input(put(date,$20.),anydtdtm.);
run;

Thanks,
Adithya

Re: Character to numeric conversion of datetime

Reeza — Tue, 11 Aug 2020 16:23:32 GMT

Try =>
want_date = input(date, datetime16.)

PUT converts it to a character so if already have a character that step doesn't make sense.

Re: Character to numeric conversion of datetime

chinna0369 — Tue, 11 Aug 2020 16:25:30 GMT

Thank you Paige Miller!