Date Formatting question

[peka0027]

-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.;

[Linlin]

data have;

input dt $ 20.;

cards;

17mar2000:00:00:00

;

data want(drop=dt);

set have;

date=put(input(scan(dt,1,':'),date9.),yymmn7.);

proc print;run;

[peka0027]

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.

[Tom]

Excel does not understand SAS's syntax of placing a colon between the date and the time.

But SAS does

data xx;

  input date1 $20.;

  new_date=datepart(input(date1,datetime.));

  format new_date yymmn6.;

  new_char=put(datepart(input(date1,datetime.)),yymmn6.);

  put (date1 new_date new_char) (=);

cards;

17MAR2000:00:01:45

run;

date1=17MAR2000:00:01:45 new_date=200003 new_char=200003