Excel-date format

[DavidDemeyer]

Hi everyone,

How can I read this type of dates in eGuide?

Tuesday, 11th June 1985

Monday, 4th June 1990

Thx!

David

[TomKari]

I don't think you'll be able to read these without doing some further processing. Are they always in the form

<weekday>, <date>th <month> <year>

If they are, it is very easy to reformat them to be converted.

Tom

[DavidDemeyer · Accepted solution]

Tis fixed the problem:

data test;

F5='Friday, 10th January 1986';

worddate=left(scan(F5,2,','));

day=substr(worddate,1,2);

monthname=scan(worddate,2, ' ');

month=substr(monthname,1,3);

year=scan(worddate,3,' ');

date9=input(catt(day,month,year),date9.);

run;

proc print ; run;

[TomKari]

Perfect. That's exactly the way to do things like this in SAS.

Your day assignment may not work with single digit dates.

day=substr(worddate,1,(notdigit(worddate)-1));

should fix it.

Tom