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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||
| 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 |