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

Is Microsoft Office required to be installed to the SAS Servers in order to generate or import ?

Reply
Occasional Contributor
Posts: 6

Is Microsoft Office required to be installed to the SAS Servers in order to generate or import ?

Hi,

 

We have several SAS programs which either import Excel files for templates or generate Excel and Word files for reports.  Is it required to have Microsoft Office installed to the SAS machines in order to import files or generate documents or is it naitively supported in SAS 9.4 (using Microsofts newer XML format)?

 

Any information you can provide would be greatly appreciated.

 

Thanks,

 

 

New Contributor
Posts: 2

Re: Is Microsoft Office required to be installed to the SAS Servers in order to generate or import ?

Short answer is no. i.e. I would think it is natively supported through the client - and Microsoft Add-in for Office which is usually installed on the "desktop" side.
Super User
Posts: 3,186

Re: Is Microsoft Office required to be installed to the SAS Servers in order to generate or import ?

What SAS version and maintenance level do you have exactly? For example 9.4M4 is the latest maintenance level. Also what operating system does your SAS servers run on? I'm guessing it is Windows as MS Office can only be installed on servers running Windows.

 

If you want the ability to read or write Excel files in all the various forms using SAS/ACCESS to PC File Formats then I'd recommend installing the MS Office Access engine software on your SAS app server. This needs to be the 64-bit version as it has to align with 64-bit SAS. There are various versions available - this is one of them (free download):

 

https://www.microsoft.com/en-nz/download/details.aspx?id=13255

 

 

Occasional Contributor
Posts: 6

Re: Is Microsoft Office required to be installed to the SAS Servers in order to generate or import ?

Currently we are using Windows (SAS 9.3 M2 and SAS 9.4 M4) and have Office installed to the servers, but we are moving towards using SAS Grid (SAS 9.4 M4) and our consultant is reccomending using Unix which I am concerned about the move due to requirements we have to produce Office documents for our clients.

 

So installing the Access Engine allows for reading of the files but not writing, correct?

Frequent Contributor
Posts: 88

Re: Is Microsoft Office required to be installed to the SAS Servers in order to generate or import ?

Just as an aside, it is possible to generate Office documents on servers w/o Office installed there. I have done it several times for various clients. However, it requires stepping out into other technology worlds if you don't have Access for PC File Formats. For my uses, i employ .NET engines. 

 

Your best bet is to probably use the SAS/Access for PC File Formats to make it happen. See if you have it available:

 

http://support.sas.com/documentation/cdl/en/acpcref/69731/PDF/default/acpcref.pdf

 

 

 

 

 

Ask a Question
Discussion stats
  • 4 replies
  • 144 views
  • 4 likes
  • 4 in conversation