BookmarkSubscribeRSS Feed
JasmineChia
Calcite | Level 5
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
2 REPLIES 2
deleted_user
Not applicable
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?
deleted_user
Not applicable
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 2 replies
  • 800 views
  • 0 likes
  • 2 in conversation