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

SAS providers and Office Addin

Reply
Frequent Contributor
Posts: 124

SAS providers and Office Addin

Greetings all

I was looking for a quick way to see what's in a dataset before I open it with SAS, and I was able to use the sas.LocalProvider to create an ADO connection in Excel, and populate a sheet.  As I understand it, the four providers are installed when SAS is installed, so for those of us in my group who have SAS, there is no issue with not having the provider installed.  However, there are some of us who do not have SAS, and I was thinking they might also be able to use my VBA code if we can get the providers installed.  I did find them available for download from SAS, but I do not know if they will work if SAS is not installed on the machine.  Also, I was wondering how to get the Office Addin, and whether or not SAS needs to be installed for that to work?  We have scads of datasets on a shared drive, and I am just looking for an easy way for users without SAS to be able to open them if they need to.  Thank you.

Greg

SAS Super FREQ
Posts: 8,645

Re: SAS providers and Office Addin

Hi:

  Aside from issues of how to get the SAS Add-in for Microsoft Office (as either part of the BI Platform install or the Office Analytics install), how about the simple (and free to download) SAS Universal Viewer??

http://support.sas.com/software/products/univiewer/index.html

cynthia

Frequent Contributor
Posts: 124

Re: SAS providers and Office Addin

Thank you Cynthia, I did not know such a thing existed.

Post a Question
Discussion Stats
  • 2 replies
  • 278 views
  • 3 likes
  • 2 in conversation