topic Re: Import Access DB file form Local drive in SAS Programming

Import Access DB file form Local drive

anilgvdbm — Fri, 12 Oct 2018 09:05:37 GMT

Dear All,

I have a file with .accdb format in my local drive and i want to import that into SAS. Please help me in this issue.

Regards,

Anil

Re: Import Access DB file form Local drive

Kurt_Bremser — Fri, 12 Oct 2018 09:10:47 GMT

Is SAS installed locally or remotely on a server?

Do you use Enterprise Guide, SAS Studio, or Display Manager as frontend?

Re: Import Access DB file form Local drive

anilgvdbm — Fri, 12 Oct 2018 09:14:26 GMT

SAS installed remotely and the accdb file also there in that sas server.

I need to convert that accdb file into sas7bdat file for my further analysis.

Regards,

Anil

Re: Import Access DB file form Local drive

Kurt_Bremser — Fri, 12 Oct 2018 10:18:28 GMT

The server has to be running on Windows, and you need SAS/ACCESS to PC Files licensed and installed.

proc import dbms=access or libname access should work (you might need to have MS ACE installed).

If your server runs on a non-Windows system, you need to set up the SAS PC Files Server on a Windows computer where the accdb files are accessible, and use dbms=accesscs.

Re: Import Access DB file form Local drive

anilgvdbm — Fri, 12 Oct 2018 12:59:19 GMT

Yes SAS/Access PC files are installed and but I'm getting an error like failed to connect to server

Please suggest me if you have any reference code or file.

Re: Import Access DB file form Local drive

Kurt_Bremser — Fri, 12 Oct 2018 13:16:21 GMT

See the documentation. The code would likely be

proc import
  datafile="\path\file.accdb"
  table="name_of_table"
  out=mylib.mydata
  dbms=access
  replace
;
run;