I’m in a really frustrating situation.
I received a dataset to be analyzed. It contains dates as follows:
<code>data DB;
input date;
cards;
2014-11- 24 00:00:00
2018-04-17 00:00:00
2019/01/02 00:00:00.0
2014 -10-13 00:00:00
2019/10/25 00:00:00.0
;run;
</code>
<code>data DB;
input date;
cards;
2014-11- 24 00:00:00
2018-04-17 00:00:00
2019/01/02 00:00:00.0
2014 -10-13 00:00:00
2019/10/25 00:00:00.0
;run;
</code>
data DB;
input date;
cards;
2014-11- 24 00:00:00
2018-04-17 00:00:00
2019/01/02 00:00:00.0
2014 -10-13 00:00:00
2019/10/25 00:00:00.0
;run;
Dates are in character mode. Moreover sometimes there are blanks, sometimes not.
Is there a way to get dates in sas format while solving all these issues?
Desired output:
<code>data DB1;
input date :date9.;
format date date9.;
cards;
24NOV2014
17APR2018
02JAN2019
13OCT2014
25OCT2019
;run;
</code>
<code>data DB1;
input date :date9.;
format date date9.;
cards;
24NOV2014
17APR2018
02JAN2019
13OCT2014
25OCT2019
;run;
</code>
data DB1;
input date :date9.;
format date date9.;
cards;
24NOV2014
17APR2018
02JAN2019
13OCT2014
25OCT2019
;run;
Thank you in advance.