topic Re: ods excel - row_heights and page break height in SAS Programming

ods excel - row_heights and page break height

xxformat_com — Wed, 03 Nov 2021 06:06:45 GMT

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.

Re: ods excel - row_heights and page break height

Norman21 — Fri, 05 Nov 2021 07:48:50 GMT

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:

Re: ods excel - row_heights and page break height

xxformat_com — Fri, 05 Nov 2021 08:05:01 GMT

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 ;