topic Re: Convert character datetime variable to numeric datetime variable in SAS Programming

Convert character datetime variable to numeric datetime variable

chinna0369 — Thu, 23 Sep 2021 20:39:07 GMT

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

Re: Convert character datetime variable to numeric datetime variable

tarheel13 — Thu, 23 Sep 2021 20:45:23 GMT

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;

Re: Convert character datetime variable to numeric datetime variable

ballardw — Thu, 23 Sep 2021 21:02:37 GMT

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;