Date:         Tue, 29 Feb 2000 15:38:42 -0500
Reply-To:     Victor Kamensky <kamensky@AECOM.YU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Victor Kamensky <kamensky@AECOM.YU.EDU>
Subject:      Info: PROC ACEES cannot use DBF files created on 02-29-2000
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: text/plain; charset="us-ascii"

Hi,SAS-L-ers!
PROC ACCESS cannot use DBASEIV (.dbf) files
created on 02-29-2000.
9543 PROC ACCESS DBMS=DBF;
9544     CREATE SASUSER.DBASE.ACCESS;
NOTE: Existing descriptor will be replaced at next CREATE or RUN.
9545       PATH="c:\sastest\test.dbf";
9546     CREATE SASUSER.DBASE.VIEW;
NOTE: The access descriptor SASUSER.DBASE was written.
9547       SELECT ALL;
9548    RUN;

NOTE: The view descriptor SASUSER.DBASE was written.
NOTE: The PROCEDURE ACCESS used 0.05 seconds.


9549    PROC ACCESS VIEWDESC=SASUSER.DBASE OUT= test ;
ERROR: Invalid Operation.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The PROCEDURE ACCESS used 0.0 seconds.

9549                                                   RUN;

I did the following: turned SAS off,changed date to 02-28-2000,
run DBASE and manually changed all files,and then changed the date back.
No more problem.
(my first attempt was to use Norton FD, but the problem remained
 in spite of the fact that file dates were changed).
But I do not know the following:
a) is there a SAS fix (in the beginning of January I had
  approximately the same problem: PROC ACCESS could not read
  dbf files with year 2000 date. I installed that fix, but
  it does not help here).
b)Will it work tomorrow?  On the next 02-29?
Victor Kamensky
Programmer
Albert Einstein College of Medicine