cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MiMe
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Long titles and small table

by Calcite | Level 5 in ODS and Base Reporting
‎05-14-2012 02:25 AM
‎05-14-2012 02:25 AM
Thank you Cynthia for your fast answer. I have SAS 9.2 and Office 2010. I tried running your code, but I still have the same problem in both worksheets as shown in the picture that is attached. I'll keep on searching the solution. BR, Miia ... View more

Long titles and small table

by Calcite | Level 5 in ODS and Base Reporting
‎05-11-2012 02:33 AM
‎05-11-2012 02:33 AM
Hi! I have a problem with titles in Excel output. I have a narrow (small) table and I would like to have title that is wider than the table. Here is example of my problem: %let title1="I would like to have this title in a one row...";                    ods tagsets.excelxp file='C:\testing titles.xls'; ods tagsets.excelxp options(embedded_titles='yes' gridlines='yes' autofit_height='yes' sheet_name='Testing'); title j=left font='Arial' height=12pt &title1 ; proc print data=sashelp.class (keep=name); run; ods tagsets.excelxp close; In SAS output it's ok, but when I open it in Excel the title is only as wide as the table and therefore it will split on two rows. Is it possible to have this in one row with this font size (it would have to be wider that the table)? TIA, Miia ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links