Desktop productivity for business analysts and programmers

Sending to Excel

Reply
New Contributor
Posts: 3

Sending to Excel

[ Edited ]

Hi!

 

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!

Esteemed Advisor
Posts: 7,293

Re: Sending to Excel

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

New Contributor
Posts: 3

Re: Sending to Excel

Thank you, I got it sorted!
Respected Advisor
Posts: 3,834

Re: Sending to Excel

[ Edited ]

@Jani1

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/ 

 

 

 

New Contributor
Posts: 3

Re: Sending to Excel

Thank you, I got it sorted! No add-in needed.
Community Manager
Posts: 2,695

Re: Sending to Excel

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).

Ask a Question
Discussion stats
  • 5 replies
  • 162 views
  • 2 likes
  • 4 in conversation