Problem Note 37095: Export markdowns to CSV incorrectly includes a comma as the thousands separator for values
 |  |  |  |  |
In SAS® Markdown Optimization, the Export to CSV function incorrectly includes a comma (the thousands separator for currency values) in the price column. When you open the CSV file in Excel, the values in the price column are incorrectly divided into 2 or more columns.
There is no workaround or solution for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#037095| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-02-11 14:41:42 |
| Date Created: | 2009-09-04 10:39:13 |