Problem Note 53344: An invalid file might be generated when the REPORT procedure is used with the ExcelXP tagset
An invalid file might be generated when the REPORT procedure is used with the ExcelXP tagset using the Minimal style. The problem is most likely to occur when PROC REPORT contains a COMPUTE block that writes out a LINE statement. When this combination occurs, a dialog box is generated and the file cannot be opened. The problem occurs because an incorrect StyleID is associated with the LINE statement when the Minimal style is used.
To circumvent the problem, do one of the following:
- Add a style template that includes the style element used for the LINE statement. See the example code below.
proc template;
define style styles.test;
parent=styles.minimal;
style linecontent from notecontent /
just=center;
end;
run;
ods tagsets.excelxp file="c:\temp.xls" style=styles.test;
proc report data=sashelp.class nowd;
compute after;
line "This is a test";
endcomp;
run;
ods tagsets.excelxp close;
- Use a style override in the PROC REPORT statement for the LINE statement. See the example code below.
ods tagsets.excelxp file="c:\temp.xls" style=minimal;
proc report data=sashelp.class style(lines)=notecontent{just=center} nowd;
compute after;
line "This is a test";
endcomp;
run;
ods tagsets.excelxp close;
Operating System and Release Information
SAS System | Base SAS | Linux for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
HP-UX IPF | 9.4 TS1M0 | 9.4 TS1M3 |
64-bit Enabled Solaris | 9.4 TS1M0 | 9.4 TS1M3 |
64-bit Enabled HP-UX | 9.4 TS1M0 | 9.4 TS1M3 |
64-bit Enabled AIX | 9.4 TS1M0 | 9.4 TS1M3 |
Windows 7 Professional x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Windows 7 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Std | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Std | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Datacenter | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2008 R2 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Pro | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8 Pro x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.4 TS1M0 | |
Z64 | 9.4 TS1M0 | 9.4 TS1M3 |
z/OS | 9.4 TS1M0 | 9.4 TS1M3 |
Solaris for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
*
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.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2014-07-09 16:31:32 |
Date Created: | 2014-06-30 11:42:38 |