topic Date Formatting question in SAS Procedures

Date Formatting question

peka0027 — Mon, 12 Mar 2012 15:22:42 GMT

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

Date Formatting question

Linlin — Mon, 12 Mar 2012 15:33:00 GMT

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;

Date Formatting question

peka0027 — Mon, 12 Mar 2012 15:34:56 GMT

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.

Date Formatting question

Tom — Mon, 12 Mar 2012 16:28:38 GMT

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