topic Re: ODS Excel center titles in ODS and Base Reporting

ODS Excel center titles

J_C — Wed, 01 Apr 2015 18:17:45 GMT

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

Re: ODS Excel center titles

juliem_sas — Mon, 06 Apr 2015 19:47:03 GMT

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#a003289858

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

I hope this helps.

Julie

Re: ODS Excel center titles

ballardw — Mon, 06 Apr 2015 20:54:42 GMT

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

Re: ODS Excel center titles

juliem_sas — Mon, 06 Apr 2015 21:00:32 GMT

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

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

and/or here:

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