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.

SAS Hackathon registration is open! Build your skills. Make connections. Enjoy creative freedom. Maybe change the world.

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.

SAS Hackathon registration is open! Build your skills. Make connections. Enjoy creative freedom. Maybe change the world.
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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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