topic Re: Reg:Excel Tagsets in ODS and Base Reporting

Reg:Excel Tagsets

sas_ — Tue, 25 May 2010 11:23:44 GMT

Hi
How can i move all the three datasets in to single excel sheet one after the other.For me the problem is it is creating three excel sheets separately how can i move all the three in to single excel sheet continously.Now i want sashelp.class to print in the same sheet for three times .
And is there any replace options as if we run the same for 2-3 times it should overwrite the old one.

ods tagsets.ExcelXP file="C:\Documents and Settings\out.xls" ;
proc print data=sashelp.class;
run;
proc print data=sashelp.class;
run;
proc print data=sashelp.class;
run;
ods tagsets.ExcelXP close;

Re: Reg:Excel Tagsets

Cynthia_sas — Tue, 25 May 2010 11:30:28 GMT

Hi:
Look at the internal help for TAGSETS.EXCELXP -- you will see it in the SAS log if you ask for the doc in a sub-option:
[pre]
ods tagsets.ExcelXP file="C:\Documents and Settings\out.xls"
options(doc='Help');
[/pre]

In the doc in the SAS log, you will find the sheet_name and sheet_interval sub-options. You should be able to use the sheet_interval sub-option to get all 3 procedure outputs in one sheet.

This paper discusses many of the sub-options that affect how the spreadsheet is created (including print headers, print footers, etc):
http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf

cynthia