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.
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
Thanks Cynthia.
I download excltags.tpl from http://support.sas.com/rnd/base/ods/odsmarkup/SAS 9.1 tagsets (.zip).
And it works.
Thanks.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.