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

Reply
SAS Employee
Posts: 1

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

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.
SAS Super FREQ
Posts: 8,819

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

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
N/A
Posts: 0

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

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;
Trusted Advisor
Posts: 2,114

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

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
Ask a Question
Discussion stats
  • 3 replies
  • 405 views
  • 0 likes
  • 4 in conversation