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,
RK
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?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.