topic Re: SAS 9.2 and LIBNAME to ACCESS Database in SAS Procedures

SAS 9.2 and LIBNAME to ACCESS Database

deleted_user — Wed, 07 Apr 2010 12:42:02 GMT

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

Re: SAS 9.2 and LIBNAME to ACCESS Database

Andre — Wed, 07 Apr 2010 12:54:52 GMT

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

Re: SAS 9.2 and LIBNAME to ACCESS Database

Andre — Wed, 07 Apr 2010 12:57:21 GMT

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

Re: SAS 9.2 and LIBNAME to ACCESS Database

deleted_user — Wed, 07 Apr 2010 13:12:45 GMT

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.

Re: SAS 9.2 and LIBNAME to ACCESS Database

andreas_lds — Thu, 08 Apr 2010 06:35:07 GMT

Use proc setinit to verify that "SAS/ACCESS Interface to PC Files" is licensed.

Re: SAS 9.2 and LIBNAME to ACCESS Database

deleted_user — Thu, 08 Apr 2010 09:06:32 GMT

yes, I have SAS/ACCESS interface to Pc files licensed.

Re: SAS 9.2 and LIBNAME to ACCESS Database

sbb — Thu, 08 Apr 2010 09:44:53 GMT

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.

Re: SAS 9.2 and LIBNAME to ACCESS Database

deleted_user — Thu, 08 Apr 2010 11:12:13 GMT

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.

Re: SAS 9.2 and LIBNAME to ACCESS Database

sbb — Thu, 08 Apr 2010 12:01:02 GMT

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.

Re: SAS 9.2 and LIBNAME to ACCESS Database

deleted_user — Thu, 08 Apr 2010 14:42:20 GMT

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?

Re: SAS 9.2 and LIBNAME to ACCESS Database

sbb — Thu, 08 Apr 2010 15:53:56 GMT

Suggest you open a SAS technical support track to address your problem symptom.

Scott Barry
SBBWorks, Inc.