Hi,
I'm not clear about the 6th value of the ROW_HEIGHTS option in ods excel.
According to the SAS Online Doc, it has to do with Page Break Height.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p09n5pw9ol0897n1qe04zeur27rv.htm
As per definition a page break has no height, I'm wondering if it has to do with a SAS specific "page break"
- something to do with the pagesize global optio?
- something to do with a specific proecure like proc report ?
- something to do with another option of ods excel such as rowbreaks_interval ?
Would you have any example to help me understand what a Page Break Height is ? I couldn't find any on the Internet.
You can change the page height as follows:
ods excel file = "C:\My SAS\_examples_\Example.xlsx" options(ROWBREAKS_COUNT='25');
proc print data=sashelp.cars;
run;
ods excel close ;
You can see the effect of changing ROWBREAKS_COUNT in Excel by selecting View, Page Break Preview:
I guess the way I phrase my question was not clear.
Let's take an example similar to yours. I use 40px for the 6th element or row_heights but I have no clue what would be impacted.
ods excel file = "&xxtest./reporting/test.xlsx"
options(row_heights='0,0,0,0,0,40px,0');
proc print data=sashelp.cars;
run;
ods excel close ;
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.