BookmarkSubscribeRSS Feed
deleted_user
Not applicable
In SAS 9.1.3 I wrote:

libname crown 'D:\Home\Tania\Biomassas\Crown ratio\arvores.mdb';

and I had the acess to the database and it´s tables. Now I´m using SAS 9.2 and Office 2007 and I can´t do it. If I run the same thing, the Log message is:

ERROR: The ACCESS engine cannot be found.
ERROR: Error in the LIBNAME statement.

If I try to create a New Library, I get the message:

ERROR:The Access engine cannot be found.
Check the SAS Log for possible additional information

Can some one tell me what I am doing wrong?

Thank you
10 REPLIES 10
Andre
Obsidian | Level 7
This is due to the facility you use
A libname has a libref and a engine
in general v9 is subtitued automatically
but how can sas guess that it is a access microsoft file

libname a access "d:\..." ;

will work (tested)

without mentionning the engine like excel ole odbc or access how can SAS guess?

HTH
Andre
Andre
Obsidian | Level 7
And the second aspect is
a access file must preexist before adding inside a new "table"
open an empty access 2007 file and retry

Andre
deleted_user
Not applicable
I have tried to run:

LIBNAME crown ACCESS "D:\Home\Tania\Biomassas\Crown ratio\arvores.mdb";

and I get the same error message.

There are several tables in the database and if I import one using the import data I have no problem. If I try to run:

proc import table="crown.res_cr2" out=cr dbms=access replace;
database="D:\Home\Tania\Biomassas\Crown ratio\arvores.mdb" ;

I get the message:
ERROR: DBMS type ACCESS not valid for import.
andreas_lds
Jade | Level 19
Use proc setinit to verify that "SAS/ACCESS Interface to PC Files" is licensed.
deleted_user
Not applicable
yes, I have SAS/ACCESS interface to Pc files licensed.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You didn't mention details about your OS platform - here is a related SAS NOTE from the SAS support website I found by doing a SEARCH with your symptom message:

Usage Note 33228: An error occurs when you use SAS® 9.2 to import or export Microsoft Excel or Access files in the Windows x64 and Windows Vista 64 environments
http://support.sas.com/kb/33/228.html


Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
I,m working on a PC with Windows 7 and Office 2007.
I´ve tried using the exemples on the Usage Note 33228 and I´m still geting an error message.
I´v found that my port is 8561, the SASSERVERNAME = 'Local' and the SASHOSTNAME = 'localhost'. I tried to run;

proc import dbms=accesscs out=AV1 replace table="SAS_1rot";
port=8561 ;
server='local.localhost.com';
database="D:\Home\Tania\Bases de Dados Eucalipto\Alto do Vilão\Eglob_AVilao.mdb";
run;

But I get:
ERROR: Failed to connect to the Server: local.localhost.com.

If I run:

libname crown pcfiles server='local.localhost.com' port=8561
path="D:\Home\Tania\Bases de Dados Eucalipto\Alto do Vilão\Eglob_AVilao.mdb";
run;

I get:
ERROR: Unable to connect to server. Please examine the pcfiles.log file for more information.
ERROR: Error in the LIBNAME statement.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
For using your local machine and using an installed ACCESS database, there is not likely to be a sub-domain "local." so you should only use either "localhost" or "0.0.0.0" which you should be able to PING on your machine.

Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
I´v tried that and I´m still geting the same error message.
I´ve been doing some research in my computer and I have "SAS/ACCESS Interface to PC Files" licensed and instaled, but I do not have the SAS PC Files Server. Could that be the problem? And if so, how do I get it?
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Suggest you open a SAS technical support track to address your problem symptom.

Scott Barry
SBBWorks, Inc.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 1993 views
  • 0 likes
  • 4 in conversation