03-12-2014 06:05 AM
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;
how to get the 15 variable next each other as in sas dataset in single PDF page?
03-12-2014 06:18 AM
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.