topic Re: ODS PDF decease output spacing in ODS and Base Reporting

Re: ODS PDF decease output spacing

twildone — Thu, 15 Sep 2016 21:22:59 GMT

Hi...I am creating a report using ODS PDF and can't seem to figure out how to change the number of rows of output on each page of the report. Right now, I am getting 34 rows of actual data on each page and there is a large space or gap between each row as if a blank row was inserted in between each row of data. I would just like to have as many rows of data on each page as possible and can fit, Thanks

Re: ODS PDF decease output spacing

ballardw — Thu, 15 Sep 2016 22:12:38 GMT

The first bit is to consider the ODS style in effect. If you didn't specify one then likely defaults to the PDF style which sets things like default Font, font size and cell padding in cells of tables.

So specify a different ODS style when creating the file.

You didn't say which procedure you are using but Procs Print, Report and Tabulate have style overrides available to control such settings on a per table, column, row or cell basis. So you could use those to use a smaller font and less cell padding to get more rows of text per output page. We would have to know your procedure code to see what you may want to set.

Also your options for Margin settings, Topmargin and Bottom margin affect how much page space is allotted to top and bottom margins.

Re: ODS PDF decease output spacing

twildone — Thu, 15 Sep 2016 22:27:55 GMT

Hi...I am using PROC Report...

Re: ODS PDF decease output spacing

Cynthia_sas — Fri, 16 Sep 2016 01:23:57 GMT

Hi:

Without data or seeing ALL of your code, nobody can try to replicate your output or really comment constructively at all on your question. Can you post your data and your code, including your options statement and your ODS statements.

cynthia

Re: ODS PDF decease output spacing

Ksharp — Fri, 16 Sep 2016 01:35:55 GMT

1) This option could make PDF as large as you want to hold those obs.
options papersize=(10cm 20cm);

2)This option could make PDF a little bigger .
options leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0;