When you export data from a table to Microsoft Excel, some of the values might unexpectedly include a minus sign. This issue can occur if you applied a user-defined format to your data that changed negative numbers to a string.

For example, here is what your original data might look like.

This user-defined format is used to convert the number values to a string.

The formatted values appear correctly in SAS Web Report Studio, as shown in this display.

However, if you export the values from the table to an Excel spreadsheet, the values that were converted from negative numbers might still include the minus sign. This problem is shown in the following display. The values that were converted from -1 to Negative appear as -Negative.

As a workaround, you can take one of the following actions.

• If possible, remove the negative values from your raw data, and modify the format accordingly.
• Create a new data item in your SAS^® Information Map that converts the negative values to positive values, and then modify your format to accommodate the new values. In your report, use the new data item instead of the original data item.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Web Report Studio	HP-UX IPF	4.31_M2		9.3 TS1M2
		64-bit Enabled Solaris	4.31_M2		9.3 TS1M2
		64-bit Enabled AIX	4.31_M2		9.3 TS1M2
		Microsoft® Windows® for x64	4.31_M2		9.3 TS1M2
		Linux for x64	4.31_M2		9.3 TS1M2
		Solaris for x64	4.31_M2		9.3 TS1M2

* 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.

---

When you export data from a table to Microsoft Excel, your values might unexpectedly include a minus sign. This issue can occur if you applied a user-defined format to your data that changed negative numbers to a string.

Type:	Problem Note
Priority:	medium

Date Modified:	2014-04-25 13:21:44
Date Created:	2014-03-25 09:51:25