Date:         Mon, 14 Jul 1997 09:22:04 -0400
Reply-To:     Victor Kamensky <kamensky@AECOM.YU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Victor Kamensky <kamensky@AECOM.YU.EDU>
Subject:      Re: Problem 2000 is in Redmond
Content-Type: text/plain; charset="us-ascii"

Hi,Tom!
I realized(thanks to all who answered) that EXCEL
converts 2-digit years 0-19 to 2000-2019.
I am not looking for a way to change EXCEL-we are getting EXCEL data
from other place and have no control over it.
My SAS solution is very simple:
   IF year(birthdat) > 1997 then  do;
        birthdat=mdy(month(birthdat),day(birthdat),(year(birthdat)-100));
                                  end;
                        end;
If it looks familiar,remember "Programming for the Job security".
This code is taken from that example with a small change:year-100.
Sincerely
Victor Kamensky
Programmer
Albert Einstein College og Medicine
 
At 05:12 PM 7/11/97 -0400, you wrote:
>Did you adjust the display format in Excel to check that
>Excel had the right century?
>
>Please let the list know the final outcome of this.
>
>Good Luck,
>
>- Tom Abernathy (tga1@columbia.edu)
>
>
>