Cynthia, Thank you for the in depth response. I was overly vague in my intial question and should have specified that I am outputting to excel via excel XP. As far as I can tell, the title row height does not adjust for how many columns I will have, and thus ends up as wide as would be necessary if the text were wrapped in a standard cell's width. Here is an snippet of my code: ods select all; ods tagsets.excelxp style=styles.slsrep10 OPTIONS ( Sheet_Name = "tabname" Sheet_Interval = 'proc' Orientation = 'landscape' FitToPage = 'yes' Pages_FitWidth = '1' Center_Horizontal = 'yes' Embedded_Titles = 'yes' Embedded_Footnotes = 'yes' Autofilter = 'yes' Frozen_Headers = '7' Row_Repeat = '1-7' Absolute_Column_Width = '7,12,12,12,12,12,12,12' ); proc report data=datasetname nowd; TITLE1 font=swiss color=black bcolor=CXFFFFFF "Title XYZ" ; Title2 font=swiss color=black bcolor=CXFFFFFF "Really REALLY REALLY REALLY long title" Title3 font=swiss color=black bcolor=CXFFFFFF "Really REALLY REALLY REALLY REALLY long title" Title4 font=swiss color=black bcolor=CXFFFFFF "Really REALLY REALLY REALLY REALLY REALLY long title" Title5 font=swiss color=black bcolor=CXFFFFFF "Really REALLY REALLY REALLY REALLY REALLY REALLY long title" column column_a column_b column_c ; define column_a / display "Column A Name"; define column_b / display "Column A Name"; define column_c / display "Column A Name"; run; ods tagsets.excelxp close;
... View more