topic Converting mmddyy to date9. in SAS Programming

Converting mmddyy to date9.

advmsj — Mon, 24 Aug 2020 16:05:49 GMT

Hi there, I am having difficulties converting dates.

Currently, the data imported from an excel sheet is shown as 081511 and I wish to convert it to 15AUG2011

Is this possible to do in a data step?

*dummy data (note I imported data from excel);

data SASIDTest;
input Date;
datalines;
090115
092616
042411
052912
071117
;
run;

Thank you in advance.

PeterClemmensen — Mon, 24 Aug 2020 16:07:42 GMT

data want;
   set SASIDTest;
   dt = input(put(Date, 8.), mmddyy8.);
   format dt date9.;
run;

advmsj — Mon, 24 Aug 2020 16:12:12 GMT

Thank you so much!