BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Aboveland
Fluorite | Level 6

Hi All,

 

I am trying to find a list of third party BI tools that i can use to read data from SAS Datasets or SAS Olap Cubes. Can you please help compile a list.

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

You can access SAS data sets with the following standard data provider protocols:

 

The SAS OLAP Server uses OLE DB for OLAP (ODBO) as its protocol, but access to SAS OLAP server from a non-SAS application isn't strictly supported.  SAS Enterprise Guide and SAS Add-In for Microsoft Office use the SAS ODBO provider to interact with SAS OLAP data.  You can use SAS language -- PROC SQL and MDX -- to pull data slices from a SAS OLAP cube.

 

You can also use Python -- via SASPy -- to read SAS data sets from an active SAS session and convert into Python pandas data frames.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

View solution in original post

2 REPLIES 2
ChrisHemedinger
Community Manager

You can access SAS data sets with the following standard data provider protocols:

 

The SAS OLAP Server uses OLE DB for OLAP (ODBO) as its protocol, but access to SAS OLAP server from a non-SAS application isn't strictly supported.  SAS Enterprise Guide and SAS Add-In for Microsoft Office use the SAS ODBO provider to interact with SAS OLAP data.  You can use SAS language -- PROC SQL and MDX -- to pull data slices from a SAS OLAP cube.

 

You can also use Python -- via SASPy -- to read SAS data sets from an active SAS session and convert into Python pandas data frames.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
AlanC
Barite | Level 11

Anything that supports ODBC is fair game. I have pulled SAS data into almost every MS Office product, SQL Server, blah, blah, blah. The list I have used them in is in the dozens but perhaps not 100.

 

OLAP is not my concern but SAS datasets are easy to read using ODBC. What OLAP product are you using? I have worked with SSAS but not the others out there.

https://github.com/savian-net

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1642 views
  • 1 like
  • 3 in conversation