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.
You can try rowbreaks_count:
ods excel options(rowbreaks_count="20");
From:
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.
Add one more statement ?
ODS TEXT=' ' ;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.