The SAS Output Delivery System and reporting techniques

ODS Excel center titles

Reply
Occasional Contributor J_C
Occasional Contributor
Posts: 18

ODS Excel center titles

Hi,

I am creating an Excel sheet with multiple tables, with the first table being two columns and the rest are 8 columns. The problem is the titles seemed to be centered with respect to the first table but not the others. Is there an option to fix that? Either making all titles centered with respect to a reference table (other than the first table) or all titles centered to their respective tables.

Thanks,

J-C

SAS Employee
Posts: 2

Re: ODS Excel center titles

Hi,

Are you using the ODS TAGSET.EXCEL statement to create the Excel sheet? If so, you can run the following code to see all of the options that are available:

ods html close;

ods tagsets.excelxp file='test.xml' options(doc='help');

ods _all_ close;

This will write the options to your SAS log. There are a few options that affect titles there.

Here is an example of how to do this in the ODS doc:

http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/viewer.htm#a003283769.htm#a0032...

http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/viewer.htm#a003283769.htm#a0032...

Just substitute "tagset.excelxp" for "tagsets.htmlpanel".

I hope this helps.

Julie

Super User
Posts: 11,107

Re: ODS Excel center titles

Also, what procedure(s) are you using? Some procedures, Print, Report and Tabulate, allow overrides and can use Excel formatting codes with some work.

SAS Employee
Posts: 2

Re: ODS Excel center titles

Ask a Question
Discussion stats
  • 3 replies
  • 500 views
  • 0 likes
  • 3 in conversation