Hi: I no longer have SAS 9.1.3 to test with. Tech Support could test your style template in 9.1.3 with TAGSETS.EXCELXP. One note, if you use the REPLACE statement in a style template, you have to respecify all the style attributes you want to keep: From the 9.1.3 doc: "If you use the REPLACE statement to create a style element in the new style definition, all style elements that inherit from that element inherit the definition that is in the new style definition. If you want to keep any attributes that are specified in the definition that is in the parent, you must respecify them in the definition that you create in the child style definition." Right now, the way you have created the template, your style element for TABLE ony has 1 attribute and the other needed attributes are going to be undefined. Also, I'm not sure that BACKGROUND=TRANSPARENT was possible in SAS 9.1.3. In addition the BORDERRIGHTWIDTH, BORDERLEFTWIDTH (etc) style attributes first were production in SAS 9.2 -- but again, Tech Support would know for sure and could help you come up with a working style template. cynthia BTW, in SAS 9.3, the code and example in the Tech Support note 45306 worked (without any changes) to create a new sheet for every unique value of AGE. In SAS 9.2, this code worked (without a custom style template) to create multisheet output: ods tagsets.excelxp file="c:\temp\multsheet.xml" style=styles.sasweb; proc tabulate data=sashelp.class; class age sex; var height; table age, sex, height; run; ods tagsets.excelxp close;
... View more
