Using the TABULATE procedure that specifies a page dimension in SAS® 9.3 generates an invalid XML file when created with the ExcelXP tagset. The problem occurs because of an invalid style value associated with the string that is used for the field added on the page dimension. Attempting to open the file in Excel generates a dialog box containing a table error.

To circumvent the problem, add a style template that includes the invalid style that allows the file to be opened in Excel. An example is shown below.

ods path(prepend) work.templat(update);

proc template;
   define style styles.test;
      parent=styles.default;
         style systemtitle__c__c from systemtitle;
         style systemtitle__l__l from systemtitle;
   end;
run;

ods tagsets.excelxp file="c:\temp.xml" style=styles.test;

proc tabulate data=sashelp.class;
   class age sex;
   var height;
   table age,sex,height;
run;

ods tagsets.excelxp close;  

Operating System and Release Information