A question about ods tagsets.excelxp

[summy]

ods listing close;

ods tagsets.excelxp  file="F:\Citi_code\SAS\test.xls" style=printer  options  (sheet_name= 'Print');

proc print data=sashelp.class noobs;run;

ods tagsets.excelxp options (sheet_name='freq');

proc print data=sashelp.class noobs;var sex;run;

ods tagsets.excelxp close;

ods listing;

/*********************************************************/

I find that, options  (sheet_name= 'Print') and options (sheet_name='freq') do not work,the sheets name are 'Table 1 - Data Set SASHELP.CLAS' and 'Table 2 - Data Set SASHELP.CLAS',do not display 'Print' and 'freq'.

Please help me.How can I get the sheets name?

Thanks in advance.

[Cynthia_sas]

Hi:

  In SAS 9.3, using TAGSETS.EXCELXP version 1.122, I get two different sheet names. What version of SAS are you using and what version of TAGSETS.EXCELXP (look in your SAS log).

  You could open a track with Tech Support -- but usually, they suggest that you update and test with the most current version of the tagset template for the destination.

  If you search support.sas.com, I know there is a Tech Support note about updating TAGSETS.EXCELXP to get the most current version.

cynthia

[summy]

Thanks Cynthia.

I download excltags.tpl from http://support.sas.com/rnd/base/ods/odsmarkup/SAS 9.1 tagsets (.zip).

And it works.

Thanks.