10-24-2016 11:05 AM
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?
format Date2 date10.;
10-24-2016 11:45 AM
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;
Need further help from the community? Please ask a new question.