topic Re: conver char date to format date in SAS Programming

conver char date to format date

radha009 — Tue, 12 Jun 2018 22:03:21 GMT

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

Thank you

novinosrin — Tue, 12 Jun 2018 22:06:29 GMT

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

novinosrin — Tue, 12 Jun 2018 22:09:58 GMT

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

Applying this for '-'

mmddyyd10

ballardw — Tue, 12 Jun 2018 22:27:06 GMT

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.