SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 34494: Numeric fields might be exported as text to Microsoft Office Excel from SAS® Markdown Optimization

DetailsHotfixAboutRate It
When you select Export Table ► Export to Excel in SAS Markdown Optimization, the following columns should be exported to Microsoft Office Excel as numeric. However, they are exported as text:

  • Current Price ($)
  • Last Reg Price ($)
  • Unit Cost ($)
  • Days on Clearance

Select the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x643.24.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP Professional3.24.29.1 TS1M3 SP49.2 TS2M0
Windows Vista3.24.29.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.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.