04-19-2012 04:32 PM
the row height for the first line statement ( I have more than 1 line statement for my report) is extremely big. Is there an option we can use to adjust? i noticed the Row-height option, but really don't believe it is what i need.
ods listing close;
ods tagsets.excelxp file='C:\sample.xls'
proc report data=sashelp.class nowd;
column sex name age height weight N ;
define sex / order;
define name /display;
compute before sex;
compute after sex;
line "for Gender:" s $4.;
line "Average Age:" age.mean;
line "total Weight:" weight.sum;
ods tagsets.excelxp close;
04-20-2012 12:25 AM
That does seem odd...the height of the row with the first LINE statement. This note indicated some type of problem with multiple LINE statements in a COMPUTE block: http://support.sas.com/kb/34/828.html -- not exactly what you are reporting, but indicates some kind of issue could still exist with multiple LINE statements and TAGSETS.EXCELXP.
You might want to work with Tech Support on that that question. However, in order to write out multiple summary rows, an alternative to using a LINE statement in the first place is to use multiple BREAK statements, as shown on pages 7 and 8 of this paper:
04-20-2012 12:35 AM
Thank you for looking into my problem. i tried many other ways to make it removing the extra spaces. only autofit_height option works, but it also make the appearance of report looks very strange. everything on the report was squeezed to fit the smallest height as possible. i will look into the paper you mentioned.
thank you again!