Problem Note 36087: NaN (Not a Number) errors when exporting missing detail data from an OLAP-based report to Excel
When viewing detail data for an OLAP-based report, you have the option to export the information. If the detail data contains missing values and you attempt to export the data to Excel, the missing values are treated as NaN (Not a Number) errors in the worksheet.
First, you will see the error message shown below:
The log file referenced in the message will contain the following error:
HTML ERROR in cell value : NaN
In the worksheet, the values will look like this:
There are two suggested workarounds:
- Export the data to a comma-delimited file, for example, and then import that file into Excel.
- Create a user-defined format that replaces the missing values with, for example, 0.
Operating System and Release Information
| SAS System | SAS Web Report Studio | z/OS | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft® Windows® for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows XP Professional | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows Vista | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| 64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| 64-bit Enabled Solaris | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| HP-UX IPF | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Linux | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Linux for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Solaris for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| SAS System | SAS Web OLAP Viewer for Java | z/OS | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft® Windows® for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows XP Professional | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows Vista | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| 64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| 64-bit Enabled Solaris | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| HP-UX IPF | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Linux | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Linux for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Solaris for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
*
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 |
| Topic: | Data Management ==> Data Sources ==> Cubes
Data Management ==> Manipulation and Transformation ==> Missing Values
Third Party ==> Products ==> Microsoft Office
Query and Reporting ==> OLAP (Online Analytical Processing)
Query and Reporting ==> Report Distribution
Query and Reporting
|
| Date Modified: | 2009-05-28 15:25:17 |
| Date Created: | 2009-05-28 15:13:43 |
