SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||