When you open Microsoft Excel files that have been created from a SAS Marketing Automation Export node or Communication node, you might receive the following message:
Excel found unreadable content in 'yourfile.xls'. Do you want to recover the contents of this workbook. If you trust the source of this workbook click Yes.
This problem occurs with Microsoft Excel 2007 running on a 64-bit platform and Microsoft Excel 2010 running on 32-bit and 64-bit platforms. If you open the same file in Microsoft Excel 2003, it opens correctly. The heading that the SAS® System generates in the XLS file is causing the problem.
To work around this issue, open the Excel file in Excel 2003 and save the file again. You can also choose a different export type such as a comma delimited or a positional file.
Click the Hot Fix tab in this note to access the hot fix for this issue.
There is an issue with these Foundation SAS hot fixes in which a BAK file is created when a previous version of the XSLX file exists. SAS Note 37485 "Updating Microsoft Excel workbooks or adding multiple worksheets creates .bak files replacing Excel worksheets" discusses this issue. There is no fix or workaround for this problem.
After you apply the hot fix, follow these steps:
For SAS Marketing Automation 5.3, add the preceding line to the appserver_autoexec_usermods.sas file that is located in the SAS\configuration-directory\Lev1\SASApp\ directory.
For SAS Marketing Automation 5.4 and 5.41, add the preceding line to the MarketingAutomation_autoexec_usermods.sas file that is located in the SAS\configuration-directory\Lev1\Applications\SASCustomerIntelligence5.4\ directory.
When you make this change, you execute a campaign that includes a communication node that is using an export type of Microsoft Excel. Then the resulting export file will have a .xlsx extension instead of a .xls extension. The XLSX export file can then be opened successfully with Microsoft Excel 2007 running on a 64-bit platform and Microsoft Excel 2010 running on 32-bit and 64-bit platforms.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Marketing Automation | 64-bit Enabled HP-UX | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 |
64-bit Enabled Solaris | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
64-bit Enabled AIX | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows Vista for x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows Vista | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Ultimate x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Ultimate 32 bit | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Professional x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Professional 32 bit | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Home Premium x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Home Premium 32 bit | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Enterprise x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Windows 7 Enterprise 32 bit | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows XP Professional | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2008 for x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2008 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 for x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Standard Edition | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft® Windows® for x64 | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows XP 64-bit Edition | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
HP-UX IPF | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
Linux | 5.3 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 |
A fix for this issue for SAS Marketing Automation 5.3_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C18.html#46999A fix for this issue for SAS Marketing Automation 5.4_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E08.html#46999A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#46999Type: | Problem Note |
Priority: | medium |
Date Modified: | 2012-07-23 13:04:20 |
Date Created: | 2012-07-16 09:41:37 |