Sorry I should have been more specific. I have a column of dates in this format (different dates) and want to reformat the entire column to the new format.
... View more
-importing a file to SAS from excel -contains a date in format like 17mar2000:00:00:00 imported as character -want it to be formatted like 200003 tried newdate=datepart(date1); put newdate=yymmn7.;
... View more