|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|
|Content-Type: ||text/plain; charset="us-ascii"|
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.
9546 CREATE SASUSER.DBASE.VIEW;
NOTE: The access descriptor SASUSER.DBASE was written.
9547 SELECT ALL;
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.
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?
Albert Einstein College of Medicine