topic Re: ods - how to fit tables into a single page in SAS Programming

ods - how to fit tables into a single page

riya275 — Thu, 28 Dec 2017 17:44:44 GMT

I have created a pdf with ods procedure and my report has 7 columns. i want all seven columns on the same page.

for one first page of the table i am getting them on the same page . however When the table continues on the next page there are only 6 columns and the seventh column has shifted to a separate page. How to fix this?

ods pdf file ='/folders/myfolders/sales.pdf' ;
options nodate;
/*Olympic Pipeline (LONDON) - by Probability As of 17th November 2012*/
proc report data = c1.a;
column probability____ Account_name Opportunity_Owner Last_Modified_Date 
Total_Media_Value Digital_Budget Deal_Comments;
define probability____/ order  descending 'Probability';
break after probability____/dol summarize style=[backgroundcolor=grgy ]  ;
define Account_name/  'Client';
define Opportunity_Owner /'Champ';
define Last_Modified_Date/ display 'Modified';
define Digital_Budget / SUM 'Digital Budgett' format= dollar30. ;
define Total_Media_Value / SUM 'Total Budget' format= dollar30.;
define Deal_Comments/ 'Comments';
rbreak after/ ol summarize style=[backgroundcolor= grrp color=aliceblue ];
title 'Olympic Pipeline (LONDON) - by Probability As of 17th November 2012'  ;
run;
ods pdf close;

Re: ods - how to fit tables into a single page

WarrenKuhfeld — Thu, 28 Dec 2017 17:47:17 GMT

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000531077.htm

Try increasing the paper size.

Re: ods - how to fit tables into a single page

Astounding — Thu, 28 Dec 2017 17:53:55 GMT

It's conceivable that you don't really need 30 characters to print the budget values. Try cutting back from:

format=dollar30.

to this instead:

format=dollar20.

Re: ods - how to fit tables into a single page

riya275 — Thu, 28 Dec 2017 18:00:50 GMT

Its not working

Re: ods - how to fit tables into a single page

riya275 — Thu, 28 Dec 2017 18:02:07 GMT

But how come only the first page of the table fits and the other two pages dont?

Re: ods - how to fit tables into a single page

Astounding — Thu, 28 Dec 2017 18:45:58 GMT

Sometimes, the report is just too wide to fit. (See @WarrenKuhfeld's comment ! )

You could also experiment with the Comments field. Take a look at the WRAP option and whether that might save some space by enabling you to use a narrower width.

Re: ods - how to fit tables into a single page

PGStats — Thu, 28 Dec 2017 23:15:09 GMT

You can restrict the width of certain columns with something like:

define Deal_Comments/ 'Comments' style(column)=[width=15%];

Re: ods - how to fit tables into a single page

Ksharp — Sun, 31 Dec 2017 11:22:33 GMT

options papersize=(100in 100in);