I am trying to import a table from MS Access. However the log indicates “ERROR: DBMS type ACCESS2000 not valid for import”. My MS access has 2000 file format. I am not sure why am I observing this error. I am using SAS 9.1.3 learning edition. I am also not sure if this is supported or needs some service pack (for learning edition). The code snippet is written below:
*****************************************************************
SAS Code
*****************************************************************
proc import table = 'student'
out = "table1"
dbms = access2000 replace;
database = 'C:\Documents and Settings\User\My Documents\vinay.mdb';
run;
proc print data=table1;
run;
*****************************************************************
Log file
*****************************************************************
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code);
4 %LET _EGTASKLABEL=%NRBQUOTE(Code);
5 %LET _CLIENTPROJECTNAME=%NRBQUOTE();
6 %LET _SASPROGRAMFILE=;
7
8 ODS _ALL_ CLOSE;
NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these
drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support.
9 OPTIONS DEV=ACTIVEX;
10 ODS LISTING;
11 FILENAME EGSR TEMP;
NOTE: Writing TAGSETS.SASREPORT11(EGSR) Body file: EGSR
12 ODS tagsets.sasreport11(ID=EGSR) FILE=EGSR STYLE=EGDefault
12 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared%20Files/BIClientStyles/EGDefault.css") NOGTITLE NOGFOOTNOTE
12 ! GPATH=&sasworklocation ENCODING=UTF8;
13
14 %gaccessible;
15 proc import table = 'student'
16 out = "table1"
17 dbms = access2000 replace;
ERROR: DBMS type ACCESS2000 not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
18 database = 'C:\Documents and Settings\User\My Documents\vinay.mdb';
19 run;
20
21 proc print data=table1;
ERROR: File WORK.TABLE1.DATA does not exist.
22 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
23
24
25 %LET _CLIENTTASKLABEL=;
26 %LET _EGTASKLABEL=;
27 %LET _CLIENTPROJECTNAME=;
28 %LET _SASPROGRAMFILE=;
29
30 ;*';*";*/;quit;run;
31 ODS _ALL_ CLOSE;
32
33
34 QUIT; RUN;
35
