Desktop productivity for business analysts and programmers

Sending to Excel

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

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!


Accepted Solutions
Solution
‎12-22-2017 10:10 AM
Community Manager
Posts: 3,463

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

View solution in original post


All Replies
Super User
Posts: 8,220

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: 4,797

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.
Solution
‎12-22-2017 10:10 AM
Community Manager
Posts: 3,463

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

Contributor
Posts: 31

Re: Sending to Excel

Posted in reply to ChrisHemedinger

I'm getting an error when I'm trying to send a Proc Freq out to Excel with the "Send to Excel" option in SAS EG 7.13 (SAS 9.4 M2).

 

It was working last week, and all of a sudden, I'm getting an error.

 

Any ideas?

 

Thanks,

Linda

Community Manager
Posts: 3,463

Re: Sending to Excel

@Linda_V - I suggest that you start a new topic with this question, or pursue with SAS Technical Support.  Be sure to include the details of your steps (are you using SAS Report output or data sets output from PROC FREQ?) and the detailed error message.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 1270 views
  • 3 likes
  • 5 in conversation