DATA Step, Macro, Functions and more

Import Access 2013 data to SAS

Reply
Contributor
Posts: 21

Import Access 2013 data to SAS

[ Edited ]

Is there any way I can import a table from MS-Access 2013 to SAS 9.4.

What will be the code...

Contributor
Posts: 37

Re: Import data in sas from Access 2013

Posted in reply to Deepankar

Hi,

 

proc import table="table_name"
out=lib.dataset_name

dbms=access;

uid="userid";

pwd="password";

database="filepath\filename.mdb";

run;

 

Thanks.

Contributor
Posts: 21

Re: Import data in sas from Access 2013

Posted in reply to srinath3111

as this is access 2013 (.accdb) and it supports some additional facility which is not available in an older version of access (.mdb). So I can't use this with mentioning mdb.

Super User
Super User
Posts: 9,193

Re: Import data in sas from Access 2013

Posted in reply to Deepankar

Use the appropriate dbms specfication for your file.  A list can be found at:

http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003102096.htm

Ask a Question
Discussion stats
  • 3 replies
  • 77 views
  • 0 likes
  • 3 in conversation