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