Problem Note 31753: SAS® Web Report Studio might export zeros as text values that contain many decimal places
 |  |  |  |  |
When exporting a SAS Web Report Studio report to Excel, zeros might be exported as text and include many decimal places.
This can occur because Excel treats numeric values as text when the number of digits exceeds 30. For example, a raw value such as 0.000000000000007105427357601002, which has 31 digits, might display as 0 in the report and as 0 in the underlying physical table (due to an applied format). However, the number of digits in the raw value causes Excel to treat the value as text.
When Excel receives such a number, it displays the following Problems During Load dialog box.
If you click OK, Excel will display the spreadsheet and flag the cell as Number stored as text.
As a workaround, you can select Convert to Number from the cell menu. However, the number will then appear in exponential notation (e.g., 7.105427357601E-15) because Excel truncates numeric values with more than 15 digits.
The plan for the next major release of SAS Web Report Studio is to export such values in scientific notation together with the Excel format mso-number-format:'0.0'. The combination of scientific notation plus the Excel format will cause Excel to display the exported value as 0.0 (although the actual Excel value will remain in scientific notation).
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Microsoft® Windows® for x64 | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Datacenter Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| HP-UX IPF | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||