Convert character datetime variable to numeric datetime variable

[chinna0369]

Hi,

I have date variable values as below

2018-02-26T10:05

I want to convert them to numeric datetime variable. Can anyone provide me the code.

Thanks,

Adi

[tarheel13 · Accepted solution]

data sample;
format datetime_var datetime.;
myvar='2018-02-26T10:05';
new=scan(myvar,1,'T')||''||scan(myvar,2,'T');
datetime_var=input(new,anydtdtm.);
run;

[ballardw]

There is an informat (actually several) designed to read ISO dates and datetimes.

data example;
   x="2018-02-26T10:05";
   y=input(x,E8601DT.);
   format y datetime18.;
run;