topic how to import data from ms acess file to sas environment. in SAS Health and Life Sciences

how to import data from ms acess file to sas environment.

sascreatures — Sun, 18 May 2008 13:26:38 GMT

I know the importing data from excel sheet to sas environment but my question is how to importing data from M.S acesses to sas environment.

Re: how to import data from ms acess file to sas environment.

Cynthia_sas — Sun, 18 May 2008 18:14:04 GMT

Hi:
If you have SAS/Access to PC File Formats, it includes the ability to read Microsoft Access, as well as Excel files:
http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a003103770.htm

Referring to the documentation may help you figure out how to do your import. If that doesn't help, then you might consider contacting Tech Support for more help.

To find this reference, I searched on support.sas.com with the search string:
import "Microsoft Access"

cynthia

Re: how to import data from ms acess file to sas environment.

deleted_user — Thu, 22 May 2008 00:21:45 GMT

as per my knowledge we have import procedure to import most of datafiles and databases. for msaccess database we have both command and wizard mode.wizard is used from file menu, where as command goes like this.

proc import database=
datatable=<' tablename'>
out=
replace
dbms=access;(dbms identifier needed for msaccess 97).
run;

Re: how to import data from ms acess file to sas environment.

Doc_Duke — Thu, 22 May 2008 12:57:19 GMT

IF you have SAS ODBC licensed, you can link to the Access DB with ODBC and treat the tables like sas datasets by using the libname access to ODBC.

Doc