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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.