Problem Note 31870: Hyphens are converted to an HTML tag when exported from SAS® Web Report Studio to Microsoft Excel
In a crosstabulation table, hyphens that appear within category values in the columns or the rows are converted to the HTML − tag when exported from SAS Web Report Studio to Microsoft Excel. This behavior is caused by the style that is used for the crosstabulation table as a view element. The behavior is not related to the type of data (relational or multidimensional) that is displayed in the table.
For example, if you export the data that is displayed in this crosstabulation table, the names Ian-Ng, Jane-Tan, and Judy-Koh will appear in a text editor as Ian−Ng, Jane−Tan, and Judy−Koh.
Generally, this is only a problem if you need to match the exported value to the original value from the data source.
As a circumvention, you can perform these steps:
- When exporting, instead of opening the XLS file, save it directly to disk.
- Open the XLS file in a text editor.
- Do a global search for the tag
− and replace it with - .
- Save the file.
Operating System and Release Information
| 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 |
| 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 |
*
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: | Query and Reporting
|
| Date Modified: | 2008-05-08 13:05:51 |
| Date Created: | 2008-04-23 10:27:05 |
