Converting mmddyy to date9.

[advmsj]

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 · Accepted solution]

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

[advmsj]

Thank you so much!