ODS Excel center titles

[J_C]

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

[juliem_sas]

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

[ballardw]

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

[juliem_sas]

Yep. And if you need information on style overrides, look here:

http://support.sas.com/documentation/cdl/en/proc/67327/HTML/default/viewer.htm#p0e7wgyk6rm3ppn1pny8b...

and/or here:

http://support.sas.com/rnd/base/ods/scratch/reporting-styles-tips.pdf