DATA Step, Macro, Functions and more

ods - how to fit tables into a single page

Reply
Contributor
Posts: 23

ods - how to fit tables into a single page

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;
SAS Super FREQ
Posts: 497

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

Contributor
Posts: 23

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

Posted in reply to WarrenKuhfeld

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

Super User
Posts: 6,632

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

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.

Contributor
Posts: 23

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

Posted in reply to Astounding
Its not working
Super User
Posts: 6,632

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

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.

Esteemed Advisor
Posts: 5,482

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

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

 

define Deal_Comments/ 'Comments' style(column)=[width=15%];
PG
Super User
Posts: 10,689

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

options papersize=(100in 100in);

Ask a Question
Discussion stats
  • 7 replies
  • 164 views
  • 0 likes
  • 5 in conversation