topic Re: Bringing data from Access into SAS in SAS Programming

Bringing data from Access into SAS

n6 — Thu, 17 Dec 2020 17:58:41 GMT

Here is the code:

proc import
datatable = 'FIELDRULES'
out = work.FIELDRULES
DBMS = ACCESS REPLACE;
database = "J:\path\accessfilename.accdb";
run;

Here is the error. I have seen this one so many times over the years and it is always a giant pain in the rump.

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed. See log for details.

I'm using 64-bit SAS as well as 64-bit Microsoft Office. I think I have PC Files too. Any help is appreciated. This stuff drives me crazy.

Re: Bringing data from Access into SAS

SASKiwi — Thu, 17 Dec 2020 20:58:17 GMT

To start check you have SAS/ACCESS to PC FILES licensed and installed:

proc setinit;
run;

proc product_status;
run;

Re: Bringing data from Access into SAS

n6 — Thu, 17 Dec 2020 21:57:23 GMT

Among the many other things that are generated in the log window when I run that code, I see this, which I'm assuming means I have it.

---SAS/ACCESS Interface to PC Files 31DEC2020 (CPU A)

Re: Bringing data from Access into SAS

ballardw — Thu, 17 Dec 2020 22:16:22 GMT

@n6 wrote:

Among the many other things that are generated in the log window when I run that code, I see this, which I'm assuming means I have it.

---SAS/ACCESS Interface to PC Files 31DEC2020 (CPU A)

If that was not in both the Setinit and Product_status output then that would mean it is licensed but not installed.

Re: Bringing data from Access into SAS

n6 — Thu, 17 Dec 2020 22:58:49 GMT

Oh, okay. What I pasted in the last post is what comes up when I do proc setinit. And the following comes up when I do proc product_status. So I think I have it, since it's in there for both.

For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M6

Re: Bringing data from Access into SAS

SASKiwi — Fri, 18 Dec 2020 21:43:35 GMT

If you are using 64-bit SAS then the error you are getting suggests that the Access database you are reading is 32-bit. To get around this either download and install the SAS PC Files Server, or download the 32-bit Microsoft Jet engine. Both are free so the choice is yours. Another possible option would be to save the Access database as 64-bit which your 64-bit Office should be able to do.