Problem Note 37374: Poor performance when exporting unformatted numeric data from SAS® Web Report Studio to Microsoft Excel
In SAS Web Report Studio, when exporting from the View Detail window, performance might be very slow. In addition, the log might contain the following warning message:
WARN [] com.sas.storage.jdbc.export - BESTFIT is an invalid SAS format name because does not contain the dot . character
This problem is most likely to occur if the numeric columns have no format or if they are using the standard numeric format (w.d) on the physical table. To circumvent the problem, do one of the following:
- Change the column format to something other than the standard w.d format. For example, change the format to F6. or F12.
- For com.sas.storage.jdbc, change the logging level to ERROR instead of WARN.
Operating System and Release Information
| SAS System | SAS Web Report Studio | z/OS | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
*
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: | medium |
| Date Modified: | 2009-10-09 13:01:06 |
| Date Created: | 2009-10-07 13:52:39 |
