Problem Note 18955: Numeric formats not retained when using Send To -> Microsoft Excel in SAS® Enterprise Guide®
When you try to export formatted data from SAS Enterprise Guide using
File -> Send To -> Microsoft Excel, your numeric formats will not be
retained.
To circumvent this problem, export your data to a .csv file, then open
it in Excel, and save it out to an Excel file. This can be done by
right-clicking on the data node in the Project Explorer or Project
Designer and selecting Export <table name>. Select the server on which
you wish to save this file, and in the Export window change the Save As
Type to .CSV (Comma Delimitted). Once you export the file, you can then
open the .CSV file in Excel and save it back out to an Excel (.XLS)
format.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
| Microsoft Windows NT Workstation | 4.1 | | 9.1 TS1M3 SP1 | |
| Microsoft Windows 2000 Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 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: | 2007-06-14 09:24:12 |
| Date Created: | 2006-11-10 14:29:20 |
