topic Re: Displaying Title when exporting SAS to Excel in SAS Procedures

Displaying Title when exporting SAS to Excel

deleted_user — Wed, 19 Aug 2009 13:57:14 GMT

Hello,

I am using the option tagsets.ExcelXP to "export" my SAS procedures to Excel. At the moment, even though a title is entered and is displaying in the SAS html file created, no title appear in the Excel I'm creating.

Here is the code I'm using (simplified for your benefit) :

ods listing close;
ods tagsets.ExcelXP file='\[...]\TEST101.XLS';
ods tagsets.excelxp options(sheet_name="Purchase 90%");

PROC TABULATE

[running a standard table procedure here]

TITLE1 'Data for product Purchase 90%';

RUN;

ods tagsets.excelxp options(sheet_name="Purchase 95%");

PROC TABULATE

[running a standard table procedure here]

TITLE1 'Data for product Purchase 95%';

RUN;

ods tagsets.ExcelXP close;

Any idea? Many thanks! Message was edited by: SamuelG.

Re: Displaying Title when exporting SAS to Excel

Cynthia_sas — Wed, 19 Aug 2009 15:01:46 GMT

Hi:
(You might want to post ODS questions to the ODS Forum in the future...)

With the TAGSETS.EXCELXP destination, you are NOT creating HTML files. You are creating Spreadsheet Markup Language XML files that comply with the Microsoft Office 2003 XML specification for workbooks/worksheets.

By default, the SAS title is put into the "print header" of the worksheet. So you should see it in Print Preview mode.

Otherwise, if you invoke the tagset with the suboption doc="Help", you will see that there are some other suboptions you can specify that will put the titles into the body of the worksheet. Try this:
[pre]
ods tagsets.ExcelXP file='c:\temp\title.xls' style=sasweb
options(doc="Help" embedded_titles="Yes");

proc print data=sashelp.class;
title 'this is the title';
run;

ods _all_ close;
[/pre]

The help information will be in the SAS log after this program runs.

cynthia

Re: Displaying Title when exporting SAS to Excel

deleted_user — Wed, 19 Aug 2009 19:42:56 GMT

Many thanks Cynthia!

This trick worked just fine.