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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.