conver char date to format date

[radha009]

my table date as date in format 10JUN2018:10:08:40.216 expecting 06-10-2018.

Thank you

[novinosrin]

data w;
date='10JUN2018:10:08:40.216';
new_date=datepart(input(date, datetime20.));
format new_date mmddyy10.;
run;

[novinosrin · Accepted solution]

data w;
date='10JUN2018:10:08:40.216';
new_date=datepart(input(date, datetime20.));
format new_date mmddyyd10.;
run;

Applying this for '-'

mmddyyd10

[ballardw]

Or if the existing variable is consistent you can read with the DATE9. informat:

data example;
   date='10JUN2018:10:08:40.216';
   newdate= input(date,date9.);
   format newdate mmddyyd10.;
run;

The informat will only read the first 9 characters.