Help using Base SAS procedures

Date Formatting question

Reply
New Contributor
Posts: 2

Date Formatting question

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

Super Contributor
Posts: 1,636

Date Formatting question

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;

New Contributor
Posts: 2

Date Formatting question

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.

Super User
Super User
Posts: 6,500

Date Formatting question

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

But SAS does Smiley Happy

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

Ask a Question
Discussion stats
  • 3 replies
  • 241 views
  • 0 likes
  • 3 in conversation