topic Re: Convert character as to date in SAS Programming

Convert character as to date

sathya66 — Mon, 15 Jun 2020 09:05:48 GMT

All,

we have character dates in our data (as these are read from the log).

How to convert them as date.

see below

data test;
date="Mon, 15 Jun 2020";
date1=input(date,mmddyy6.);
run;

gamotte — Mon, 15 Jun 2020 09:15:55 GMT

Hello,

data test;
format date1 date9.;
date="Mon, 15 Jun 2020";
date1=input(substr(date,6),date11.);
run;

Kurt_Bremser — Mon, 15 Jun 2020 09:16:25 GMT

date1 = input(compress(scan(date,2,',')),date9.);

Jagadishkatam — Mon, 15 Jun 2020 10:49:28 GMT

Alternatively

data test;
date="Mon, 15 Jun 2020";
date1=input(scan(date,2,','),anydtdte20.);
format date1 date9.;
run;