ODS pdf how to set pagesize

[MR19]

I'm creating a pdf report with 4 tables and I want to use PAGESIZE to set each table on one page but failed to do that.

I'm not sure where to put the PAGESIZE option and how to determine the number for it.

Here are the codes.

ods pdf file='C:\Users\Box\#4\report2.pdf';
proc print data=q6;
id Guest;
by table;
sum nonbeef;
sumby table;
var food;
title 'Summary of food order by table';
run;
ods pdf close;

[ballardw · Accepted solution]

I think that you may actually want PAPERSIZE.

Something like

Options papersize=(15in,24in);

BEFORE the ODS PDF statement would set the size to 15 inches wide and 24 inches tall.

Your should be able to reset to the default with

options papersize;

after done with the custom size.

Pagesize doesn't quite work because it specifies number lines and is OLD, like lineprinter old and intended more to work with SAS OUTPUT window destinations than ODS where the concept of a fixed line height does not apply as each "line" is determined by style settings for font size plus cell space around text and a few other things.