topic Re: fit proc print output in portrait to ODS PDF in SAS Programming

fit proc print output in portrait to ODS PDF

RajK — Thu, 26 Jun 2014 20:16:54 GMT

Hi,

Can anyone help me in creating a pdf report with 14 columns in portrait? When i do proc print to ODS PDF table has been breaking into 9 and 5 columns. I tried decreasing size of font and using split option but it didnt work. I have to add this page to 32 other pages in the report. Could any of you suggest me a way to do it without affecting options of other 33 pages?

Thanks,

Re: fit proc print output in portrait to ODS PDF

ballardw — Thu, 26 Jun 2014 21:21:25 GMT

Some things to reduce space involve using style overrides for the variable such as setting cellwidth, cellpadding to 0, reducing the width of the table boundaries, cell spacing and specifying formats for the variables sometimes helps.

What ODS style are you using and if you could provide your proc print code we might be able to add some other specific suggestions.

You may also need to play with page margins as 14 columns on 8 or 8.5 inch paper if you are defaulting to 1 inch margins leaves your columns to be pretty narrow.

Are any of your variables text?

Re: fit proc print output in portrait to ODS PDF

Reeza — Thu, 26 Jun 2014 21:36:55 GMT

Sample data helps.

For the style needed, I sometimes pull the data into excel or word to determine what font/cell width I need to specify. It's easier to drag and click rather than type and guess sometimes

Then I pull that info back into SAS to automate things.