SAS ODS PDF not holds all variable from SAS Data sets

Reply
Frequent Contributor
Posts: 88

SAS ODS PDF not holds all variable from SAS Data sets

Hi,

I have SAS Dataset with 15 columns, I am not able to get 15 variables in  data PDF docuemnt as in SAS Dataset.

The PDF first page holds 1-5 variables and data, second page print 6-10 variables and data and third page prints variables from 11-15 and data.

i have used code;

ODS PDF file="path.test.pdf";

proc print data=dataset;

run;

ODS close;

how to get the 15 variable next each other as in sas dataset in single PDF page?

Thx- Ravi

Super User
Super User
Posts: 7,430

Re: SAS ODS PDF not holds all variable from SAS Data sets

There are many options which you can try, but do remember the paper size is only so big.  Try some of the below:

- options orientation=landscape - this sets the page horizontal rather than vertical to allow to fit more left to right but less rows.

- options papersize, not this myself, but changes page size

- switch to using proc report - its more powerful and you can set widths for each variable individually e.g:

proc report data=xx ls=256 ps=20

      nowindows  headline headskip missing center split="~" panels=1 style(column)=[outputwidth=4cm ];

  column pge avar;

  define pge      / noprint order;

  define avar     / 'A Variable' width=16 style(column)=[just=l cellwidth=2.8cm] style(header)=[just=l];

...

Note the cellwidth in the style.

Ask a Question
Discussion stats
  • 1 reply
  • 137 views
  • 0 likes
  • 2 in conversation