BookmarkSubscribeRSS Feed
BigD
Calcite | Level 5

Hi,

I have a two page report that I'm making. The first page is just two tables so a 8.5 X 11 page size is good. However the second page has two columns of five graphs and it fits well on a 8.5 by 14 page size. I've tried:

     end of first page code

ods layout end;

ods pdf startpage=now;

ods layout start height = 14in width = 8.5in;

but it just doesn't work.

Any tips to get past this one?

Thanks,

Bruce

3 REPLIES 3
art297
Opal | Level 21

Did you take a look at a previous response to this question, namely https://communities.sas.com/message/19235#19235

The size has to be set first and, unless there is something I'm not aware of, you could produce the two pdf files and then combine them outside of SAS.

BigD
Calcite | Level 5

The reply suggests to make two pdfs. No really a solution. As this report is a daily report, I really don't want to be adding more steps...

Thanks,

Bruce

BigD
Calcite | Level 5

A little more searching found this:

http://analytics.ncsu.edu/sesug/2011/BB15.Welch.pdf

which I hard coded to :

Dim Doc1
Dim Doc2


Set Doc1 = CreateObject("AcroExch.PDDoc")
Set Doc2 = CreateObject("AcroExch.PDDoc")

file1 = Doc1.Open("C:\ods_outputs\alc_report printer.pdf")
file2 = Doc2.Open("C:\ods_outputs\_2011_12_alc_comparative.pdf")
Stack = Doc1.InsertPages(Doc1.GetNumPages - 1, Doc2, 0, Doc2.GetNumPages, 0)

SaveStack = Doc1.Save(1, "C:\ods_outputs\combined.pdf")

and it worked!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1104 views
  • 0 likes
  • 2 in conversation