topic Re: A question about ods tagsets.excelxp in ODS and Base Reporting

A question about ods tagsets.excelxp

summy — Mon, 24 Sep 2012 14:38:27 GMT

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.

Re: A question about ods tagsets.excelxp

Cynthia_sas — Mon, 24 Sep 2012 19:50:54 GMT

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

Re: A question about ods tagsets.excelxp

summy — Tue, 25 Sep 2012 15:29:13 GMT

Thanks Cynthia.

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

And it works.

Thanks.