Convert Text Datetime of format YYYY-MM-DDThh:mm:ss.000Z to SAS Datetime

[vfarmak]

Greetings Everyone!

I have the following question:

I have date stored in a character format (24) and I want to convert it to a datetime format.

The date is stored in this type of format

2020-12-03T14:00:00.000Z

I tried Input(<field>, datetime24.) with no luck.

As an example I have the following row:

ID	Date
000000039	2020-11-04T08:30:00.000Z

Any help is appreciated.

Thank you in advance, 

[ballardw · Accepted solution]

data example;
   charvar ="2020-11-04T08:30:00.000Z";
   dt = input(charvar,e8601dz.) ;
   format dt datetime18.;
run;