BookmarkSubscribeRSS Feed
J_C
Calcite | Level 5 J_C
Calcite | Level 5

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

3 REPLIES 3
juliem_sas
SAS Employee

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
Super User

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-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1439 views
  • 0 likes
  • 3 in conversation