BookmarkSubscribeRSS Feed
Deepankar
Calcite | Level 5

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

What will be the code...

3 REPLIES 3
srinath3111
Quartz | Level 8

Hi,

 

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

dbms=access;

uid="userid";

pwd="password";

database="filepath\filename.mdb";

run;

 

Thanks.

Deepankar
Calcite | Level 5

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.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1180 views
  • 0 likes
  • 3 in conversation