09-15-2017 11:07 AM
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.
09-15-2017 03:54 PM
09-15-2017 07:32 PM
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):
09-20-2017 03:16 PM
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?
09-16-2017 12:48 AM
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: