You could use option "Row_Heights=".
ODS TAGSETS.EXCELXP
file="C:\temp\test.xls"
STYLE=Printer
OPTIONS (
Sheet_Name = "NEW"
Orientation = 'landscape'
FitToPage = 'no'
Pages_FitWidth = '1'
Pages_FitHeight = '100'
embedded_titles = 'yes'
Row_Heights='0,40,0,0,0,0,0'
) ;
PROC REPORT DATA=sashelp.cars nowd
style(header)=[fontfamily=helvetica fontsize=8pt textalign=l]
style(column)=[fontfamily=helvetica fontsize=8pt textalign=l TAGATTR='format:text'];
columns make model type origin msrp drivetrain horsepower mpg;
DEFINE mpg / STYLE(column)={cellwidth=10cm};
RUN;
ods tagsets.excelxp close;
... View more