topic Re: ODS Excel - Control space between reports in ODS and Base Reporting

ODS Excel - Control space between reports

KonstantinVasil — Mon, 25 Feb 2019 11:49:18 GMT

In ODS Excel, the option sheet_interval="none", leads to one blank row between reports. How can one increase this to two blank rows, or how can this spacing be controlled in general?

I have seen a solution to this before but I can't find it again after a lot of searching. I will include a link or delete this post as soon as I find it.

Re: ODS Excel - Control space between reports

RW9 — Mon, 25 Feb 2019 12:27:27 GMT

You can try rowbreaks_count:

ods excel options(rowbreaks_count="20");

From:

https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en

Re: ODS Excel - Control space between reports

KonstantinVasil — Mon, 25 Feb 2019 12:36:01 GMT

I just tried and there is still only one blank row between reports. Furthermore, from the documentation, the option seems to control after how many rows to insert a break? Instead, I am looking for controlling how many row breaks to insert after each report on the same sheet.

Re: ODS Excel - Control space between reports

Ksharp — Mon, 25 Feb 2019 12:50:12 GMT

Add one more statement ?

ODS TEXT=' ' ;