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;
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000531077.htm
Try increasing the paper size.
But how come only the first page of the table fits and the other two pages dont?
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.
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.
You can restrict the width of certain columns with something like:
define Deal_Comments/ 'Comments' style(column)=[width=15%];
options papersize=(100in 100in);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.