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"
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;
If it looks familiar,remember "Programming for the Job security".
This code is taken from that example with a small change:year-100.
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.
>- Tom Abernathy (email@example.com)