Problem Note 64900: An invalid file is created when you replay PROC TABULATE output by using the DOCUMENT procedure to the ODS TAGSETS.EXCELXP destination
 |  |  |  |
Replaying output using the DOCUMENT procedure, which is generated by the TABULATE procedure, can generate an invalid file that cannot be opened in Microsoft Excel.
When this issue occurs, a Problems During Load window appears in Excel that contains the following error message:
This file cannot be opened because of errors. Errors are listed in: directory-path-to-Microsoft-Office-logs
The problem occurs because the structure of the file is invalid.
The following code is an example of syntax that creates the invalid file:
libname outfinal "C:\temp";
ods document name=outfinal.tabulate (write) ;
proc tabulate data=sashelp.class;
class age sex;
var weight height;
table age, sex*(weight height);
run;
ods document close ;
proc tabulate data=sashelp.class;
class age sex;
var weight height;
table age, sex*(weight height);
run;
ods document close ;
ods tagsets.excelxp file ="c:\temp\Test_Tabulate.xml";
proc document name=outfinal.tabulate;
replay ;
run;
quit;
replay ;
run;
quit;
ods tagsets.excelxp close;
The workaround for this type of code is to use the ODS EXCEL destination instead of the ODS TAGSETS.EXCELXP destination.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.4 | 9.4 TS1M0 | ||
| z/OS 64-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft® Windows® for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4 TS1M0 | ||||
| Windows 7 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Windows 7 Professional x64 | 9.4 | 9.4 TS1M0 | ||||
| 64-bit Enabled AIX | 9.4 | 9.4 TS1M0 | ||||
| 64-bit Enabled Solaris | 9.4 | 9.4 TS1M0 | ||||
| HP-UX IPF | 9.4 | 9.4 TS1M0 | ||||
| Linux for x64 | 9.4 | 9.4 TS1M0 | ||||
| Solaris for x64 | 9.4 | 9.4 TS1M0 | ||||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-10-11 10:57:23 |
| Date Created: | 2019-10-09 14:27:48 |