Convert character as to date

[sathya66]

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 · Accepted solution]

Hello,

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

[Kurt_Bremser]

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

[Jagadishkatam]

Alternatively

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