Hello,
I have 4-Aug-2016 ($20.) , 05-Aug-2016 ($20.) and I want to convert it into a proper date foramt. The following does not work. Could someone suggest a proper method to do it?
data want;
set have;
Date2= input(Date,worddate.);
format Date2 date10.;
run;
Thanks
One example:
data have; length dt $20; dt="4-Aug-2016"; output; dt="05-aug-2016"; output; run; data want; set have; d2=input(compress(dt," -"),date9.); format d2 date9.; run;
One example:
data have; length dt $20; dt="4-Aug-2016"; output; dt="05-aug-2016"; output; run; data want; set have; d2=input(compress(dt," -"),date9.); format d2 date9.; run;
Typo, its not needed.
The answer is already solved, just wanted to mention, that the date11 informat can read the dates that are shown.
See sample code below:
data have;
length dt $20;
dt="4-Aug-2016"; output;
dt="05-aug-2016"; output;
run;
data want;
set have;
d2 = input(dt, date11.);
format d2 date9.;
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.