Importing data from Microsoft Access DB (2007/2010) with SAS 9.2

[miaJ]

Just wondering if this was resolved. I am having the same issue...

[SASKiwi]

Do you have SAS/ACCESS for PC Files licensed? Run:

PROC SETINIT NOALIAS;
RUN;

to confirm. This product allows you to import ACCESS databases directly.

[lsirakos]

SASKiwi wrote:

Do you have SAS/ACCESS for PC Files licensed? Run:

PROC SETINIT NOALIAS;
RUN;

to confirm. This product allows you to import ACCESS databases directly.

I do have SAS/ACCESS for PC Files

[Linlin]

a paper:

http://www.lexjansen.com/pharmasug/2005/coderscorner/cc12.pdf

[SteveDenham]

Here is another method, ported from 9.2 to 9.3, using Proc Import.  It also requires SAS/ACCESS for PC Files.

PROC IMPORT OUT= WORK.NewBISRT

            DATATABLE= "BISNewRT"

            DBMS=ACCESS REPLACE;

     DATABASE="B:\BIS Report Tracking\New BIS RT.mdb";

     SCANMEMO=YES;

     USEDATE=NO;

     SCANTIME=YES;

RUN;

Steve Denham

[Sisi]

Hi,

This is an old question, but just posting incase if it may help someone. I had the same problem with SAS V9.3 (importing to SAS from Access database having accdb extension). For me, the trick was to incorporate the password which was linked to the Access database, as that will be needed if you want to import individual tables to SAS (DBPWD option below).

I first used the SAS interface to import individual access individual tables (have only a few  i.e 7 tables) and the below is the SAS syntax file that was produced (imported succesfully to SAS):

Libname fin "D:\study"; /*libname where you will store your SAS data for Table1*/

PROC IMPORT OUT= fin.table1

DATATABLE="Table One" DBMS=ACCESS REPLACE; /* name of the particular table you want to import from Access database*/

DATABASE="D:\Study\accessdatabase.accdb";              /* location and name of the Access database*/

DBPWD="accessdatabasepassword";         /* the access database password, that you use to open the  access database, if exists*/

SCANMEMO=YES;USEDATE=NO; SCANTIME=YES;

RUN;