Hello EG-users.
I'm new to EG. I used SAS 9.1.3 at my previous job.
I'm trying to import MS Access table but i'm getting an error:
ERROR: DBMS type ACCESS not valid for import.
The code that i use is below:
proc import table="a403" dbms=access out=a database="\\sasabm01.region.psb.de\uolib\101_24.mdb"; run;
I tried DBMS=ACCESS97, =ACCESS2000, =ACCESS2002 but i get the same error.
Access to PC files is licensed.
What dbms do i have to use in EG 4.3?
Thanks in advance.
Oleg.
If you are using a 64bit version you have to use ACCESSCS
Take a look at: http://support.sas.com/kb/33/228.html
Thank you Art. The server operating system is Windows server 2000 64bit (as i know).
The code below generates an error:
ERROR: Failed to connect to the Server: sasabm01.region.psb.de
proc import dbms=accesscs
out=a replace table='a403'; port=8621; server="sasabm01.region.psb.de"; database='\uolib\101_24.mdb'; run;
What am I doing wrong?
Oleg.
Are you using the SAS PC files server and is the name correctly identified?
Thanks for your reply.
I will ask system administrator tomorrow about this details.
Oleg.
What is "SAS PC Files Server"?
Where can i find it?
For Microsoft Access files, you must use the SAS PC Files Server, as shown in these examples:
proc import dbms=accesscs out=sas-data-output-filename replace table='accessmdb-table-name'; port=8621; server="server-name.company.com"; database='\directory\filename.mdb'; run;
proc export data=sashelp.shoes outtable='accessmdb-table-name' dbms=accesscs replace; database='\directory\filename.mdb'; server="server-name.company.com"; port=8621; run;
Here is a pointer to the documentation: http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003352567.htm
Thanks for your reply.
There is no SAS PC Files Server at my workstation.
I use EG 4.3
What should i do?
The server can be manually set to run as a Windows service.
To run as a Windows service, select Start Control Panel Administrative Tools Services.
Locate SAS PC Files Server in the Name column. Select Properties.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.