06-26-2014 04:16 PM
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?
06-26-2014 05:21 PM
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?
06-26-2014 05:36 PM
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.