Hi, As my code and screenshots above show, the height of the rows is automatically adjusted when I set the width of the columns. However, I don't understand why you are changing every possible value for ROW_HEIGHTS. Are you using PARSKIP? does your code have BYLINES, why bother to change those heights if you don't have them in your code? For example, in the code below, I change the table headers, table rows, title and footnote rows. I am changing ALL the title rows and ALL the footnote rows to be the same. I am changing ALL the "body/data" rows to be the same. If you are still having issues with Row Height, then I suggest you open a track with SAS Tech Support. cynthia title; ods listing close; /* For the ROW_HEIGHTS suboption, the default values are: Table_head : 0 Table : 0 Byline : 0 Title : 0 Footer : 0 PageBreak : 0 Parskip : 0 row_heights='table_head,table,byline,title,footer, pagebreak,parskip' */ ods _all_ close; ods tagsets.excelxp file='c:\temp\heights.xml' options(doc='help' embedded_titles='yes' embedded_footnotes='yes' row_heights='30,20,0,50,70,0,0') style=sasweb; proc report data=sashelp.class(obs=3) nowd; title j=l 'Title1:'; title2 j=l 'Title2:'; title3 j=l 'Title3:'; footnote 'The Footnote'; column age sex name height weight; define age / order style(header)={cellwidth=2in}; define name / style(header)={cellwidth=2in}; define weight / style(header)={cellwidth=2in}; run; ods tagsets.excelxp close;
... View more