Usage Note 50005: When using HTML and CSV results in the SAS® Add-In for Microsoft Office, values that contain a slash (/) or a hyphen (-) might be interpreted as dates
When using the SAS Add-In for Microsoft Office with Microsoft Excel, values that contain a slash (/) or a hyphen (-) might be interpreted as dates. This problem occurs if the Results Format is either HTML or CSV.
The Add-In is not performing the conversion. The conversion is being done by Microsoft Excel. For more information about the issue, see Microsoft Knowledge Base article 214233.
To circumvent this issue, select SAS ► Tools ► Options ► Results. In the Format list, select SAS Report. In the Display section, deselect Allow Excel to interpret value type in SAS Report tables option.
Operating System and Release Information
SAS System | SAS Add-in for Microsoft Office | Windows 7 Ultimate 32 bit | 5.1 | | | |
Windows 7 Professional x64 | 5.1 | | | |
Windows 7 Professional 32 bit | 5.1 | | | |
Windows 7 Home Premium x64 | 5.1 | | | |
Windows 7 Home Premium 32 bit | 5.1 | | | |
Windows 7 Enterprise x64 | 5.1 | | | |
Windows 7 Enterprise 32 bit | 5.1 | | | |
Microsoft Windows XP Professional | 5.1 | | | |
Microsoft Windows Server 2012 Std | 5.1 | | | |
Microsoft Windows Server 2012 Datacenter | 5.1 | | | |
Microsoft Windows Server 2008 for x64 | 5.1 | | | |
Microsoft Windows Server 2008 | 5.1 | | | |
Microsoft Windows Server 2003 for x64 | 5.1 | | | |
Microsoft Windows Server 2003 Standard Edition | 5.1 | | | |
Microsoft Windows Server 2003 Enterprise Edition | 5.1 | | | |
Microsoft Windows Server 2003 Datacenter Edition | 5.1 | | | |
Microsoft Windows NT Workstation | 5.1 | | | |
Microsoft Windows 2000 Professional | 5.1 | | | |
Microsoft Windows 2000 Server | 5.1 | | | |
Microsoft Windows 2000 Datacenter Server | 5.1 | | | |
Microsoft Windows 2000 Advanced Server | 5.1 | | | |
Microsoft Windows 95/98 | 5.1 | | | |
Microsoft Windows 8 Pro | 5.1 | | | |
Microsoft Windows 8 Ent | 5.1 | | | |
Microsoft® Windows® for x64 | 5.1 | | | |
Windows Vista for x64 | 5.1 | | | |
Windows Vista | 5.1 | | | |
Windows Millennium Edition (Me) | 5.1 | | | |
Windows 7 Ultimate x64 | 5.1 | | | |
*
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.
Date Modified: | 2013-05-23 08:11:08 |
Date Created: | 2013-05-22 03:33:14 |