Problem Note 41132: Unable to export data to an .xlsx file from SAS® Enterprise Guide®
For use with SAS Enterprise Guide 4.3x, you can download a custom add-in task that enables you to export data to an .xlsx file.
To download and use the custom task for SAS Enterprise Guide 4.3x, follow these steps:
- Close SAS Enterprise Guide.
 
- Click the following link to save the .zip file to your local machine.
 
Export to Microsoft Excel 2007/2010 Custom Add-In Task for 4.3
- Extract the .dll file and save it to your local machine.
 
- Open SAS Enterprise Guide, and select Tools ► Add-In ► Add-In Manager. 
 - In the Add-In Manager, click Browse and select the .dll file that you just saved. Click OK to close the Add-In Manager.
 
After installing the custom task, you can select Tools ► Add-In ►Export to Microsoft Excel 2007/2010 to export data to an .xlsx file.
In SAS Enterprise Guide 5.1x, you can use the built-in Export task in order to export data to an .xlsx file.
 
However, you also can use a 5.1x version of the custom add-in task in order to export data to an .xlsx file. To do so, use steps similar to the above, along with the custom task available from this link:
 Export to Microsoft Excel 2007/2010 Custom Add-In Task for 5.1
Note: This custom add-in task will not be updated beyond SAS Enterprise Guide 5.1x.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 |  | 9.2 TS2M0 |  | 
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 |  | 9.2 TS2M0 |  | 
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 |  | 9.2 TS2M0 |  | 
| Microsoft Windows Server 2003 Standard Edition | 4.2 |  | 9.2 TS2M0 |  | 
| Microsoft Windows Server 2003 for x64 | 4.2 |  | 9.2 TS2M0 |  | 
| Microsoft Windows Server 2008 for x64 | 4.2 |  | 9.2 TS2M0 |  | 
| Microsoft Windows XP Professional | 4.2 |  | 9.2 TS2M0 |  | 
| Windows Vista | 4.2 |  | 9.2 TS2M0 |  | 
| Windows Vista for x64 | 4.2 |  | 9.2 TS2M0 |  | 
*
        For software releases that are not yet generally available, the Fixed
        Release is the software release in which the problem is planned to be
        fixed.
       
| Type: | Problem Note | 
| Priority: | high | 
| Date Modified: | 2013-01-25 08:33:08 | 
| Date Created: | 2010-10-04 16:33:36 |