Is there any way I can import a table from MS-Access 2013 to SAS 9.4.
What will be the code...
Hi,
proc import table="table_name"
out=lib.dataset_name
dbms=access;
uid="userid";
pwd="password";
database="filepath\filename.mdb";
run;
Thanks.
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.