Desktop productivity for business analysts and programmers

Third Party BI Tools supporting SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Third Party BI Tools supporting SAS

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!


Accepted Solutions
Solution
‎02-08-2018 02:04 AM
Community Manager
Posts: 3,462

Re: Third Party BI Tools supporting SAS

Posted in reply to Aboveland

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.

View solution in original post


All Replies
Solution
‎02-08-2018 02:04 AM
Community Manager
Posts: 3,462

Re: Third Party BI Tools supporting SAS

Posted in reply to Aboveland

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.

Regular Contributor
Posts: 150

Re: Third Party BI Tools supporting SAS

Posted in reply to Aboveland

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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