topic Re: Excel-date format in SAS Enterprise Guide

Excel-date format

DavidDemeyer — Mon, 06 May 2013 11:23:55 GMT

Hi everyone,

How can I read this type of dates in eGuide?

Tuesday, 11th June 1985

Monday, 4th June 1990

Thx!

David

TomKari — Sun, 12 May 2013 16:28:33 GMT

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

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

Tom

DavidDemeyer — Mon, 13 May 2013 11:57:29 GMT

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 — Mon, 13 May 2013 13:03:51 GMT

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