SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Retrieving data using Microsoft Access

Reply
Occasional Contributor
Posts: 5

Retrieving data using Microsoft Access

Good day,
Is it possible for me to obtain data from SAS data set using Microsoft Access without writing code in Base SAS, ie. using SAS ODBC?

Currently i'm trying to use Microsoft Access to retrieve data from SAS data set that is residing on a UNIX server.

Thanks
N/A
Posts: 0

Re: Retrieving data using Microsoft Access

I'm not a great user of Access, but in Excel you have the Data, Import External data, import option which you can setup a link to any data source. Am sure that there is an equivalent in Access?
N/A
Posts: 0

Re: Retrieving data using Microsoft Access

Yes. You can retrieve data from Microsoft Access with a SAS module that has been named Access to PC File formats. This works fine in plain SAS and more comfortably using Enterprise Guide.

I hope this will help.

Pablo
Post a Question
Discussion Stats
  • 2 replies
  • 171 views
  • 0 likes
  • 2 in conversation