ProBBQ Excel 20 User Manual download pdf (Page 28)

Can I Include Titles and Specify the Sheet Name?

Options are available:

• Set the worksheet name prefix.

• SAS will use to create a separate worksheet for each by group.

• Titles (if any), are now imbedded in the worksheet itself.

• Many, many more options.

ods tagsets.excelxp file='c:\temp\test.xml'

options(embedded_titles='Yes' Sheet_Name='State');

proc print data=softsale(obs=5) noobs;

var Name Division Years Sales Expense State;

by state;

title 'Softsale First 5 Obs';

run;

ods tagsets.excelxp close;

Choosing the Right Tool from Your SAS

and Microsoft Excel

Tool Belt

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 97 98

No comments

ProBBQ Excel 20 User Manual Page 28