topic how can I eliminate the empty row after proc report when using ods excel? in ODS and Base Reporting

how can I eliminate the empty row after proc report when using ods excel?

WaltSmith — Wed, 15 Apr 2020 22:05:57 GMT

I'm producing a workbook with several tabs and on each tab are 2 graphs followed by 4 short tables each table produced by proc report. Proc report adds an empty row after each table which I would like to eliminate but I find no method to do so. I've investigated using a blank footnote statement (doesn't do it), a custom template (I don't see a way with this), I tried defining an ods excel options with absolute_row_height = "a string of row height numbers" but it ignores the last (the key) row height. Is there any way to eliminate this empty row? (using SAS 9.4 (TS1M6))

Re: how can I eliminate the empty row after proc report when using ods excel?

Cynthia_sas — Sun, 19 Apr 2020 00:08:32 GMT

Hi:

Without getting into the issue of graphs yet, take a look at this, with 3 PROC REPORTS in one sheet:

With 3 procedures, there is an empty row 4 between proc report 1 and 2 and then empty row 9 between proc report 2 and 3. If I understand you correctly, you want to eliminate the row entirely? In other words, you want PROC REPORT #2 to start on Row 4???

Assuming you want to keep the column headers, I think you just want the Row_Heights suboption, as shown below:

These are positional parameters and the last in the list is the "paragraph skip" which is the value used for the "skip" between tables. As you can see, a really small size (2px) caused row 4 and row 9 to get very tiny.

Hope this helps,

Cynthia

Re: how can I eliminate the empty row after proc report when using ods excel?

WaltSmith — Mon, 20 Apr 2020 20:28:19 GMT

Thanks Cynthia, I knew about absolute_row_height (I tried that and got some very unexpected results) but I didn't know that row_heights was different than absolute_row_height. row_heights solves my problem.