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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.