ODS Excel - Control space between reports

[KonstantinVasil]

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.

[RW9]

You can try rowbreaks_count:

ods excel options(rowbreaks_count="20");

From:

https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVe...

[KonstantinVasil]

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.

[Ksharp · Accepted solution]

Add one more statement ?

ODS TEXT='           '   ;