05-16-2017 05:34 PM - last edited on 05-16-2017 05:51 PM by Reeza
I'm hoping someone could help me. When I want to export/send my results to Excel, SAS tells me: It is unable to send the report to Excel. A compatible version of the SAS Add-in for Microsoft office is either not installed or not enabled for Microsoft Excel.
I have enabled all the SAS add-ins that I could possibly see in Excel, how can I go about fixing this problem? I feel very lost at this point and unsure how to enable the add-ins or how to find them to install them.
Thank you for the help in advance!
05-16-2017 05:55 PM
Do you license sas/access for pcfile formats? That's necessary, I think, to do what you want.
If you do, show the code you ran and indicate whether your Excel files are 32 or 64 bit.
Art, CEO, AnalystFinder.com
05-16-2017 06:11 PM - edited 05-17-2017 05:09 PM
Can you please share your code and log or at least explain a bit more what exactly you're doing?
The SAS Add-In for Microsoft Office is typically used in a setting where Excel is the client and you then connect out of Excel to SAS. It appears you're trying to do something different.
You can use SAS to write to Excel but that doesn't required the SAS Add-In for Microsoft Office as much as I know.
Here some of the options: http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/
05-17-2017 08:09 AM
Some explanation for those coming late to this or who are curious.
Send To Excel is available from the data viewer in SAS Enterprise Guide. You don't need SAS Add-In for Microsoft Office or SAS/ACCESS to PC Files. This feature works by automating Excel and populating a sheet with records from the active data set. For large data, it can take a while -- but for most data, it's quick and easy. However, it's an interactive method only -- not captured in a program or in the process flow.
My guess is that at first, @Jani1 was looking at the options for ODS results (SAS Report) and saw that Send To Excel was not available -- that does require SAS Add-In for Microsoft Office. However, if you want to send your report to Excel, the best way (now) is to enable Excel as an ODS destination, available in Tools->Options->Results in EG 7.13 (supported with SAS 9.4m3 and later).