11-06-2012 03:55 PM
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?
11-06-2012 04:16 PM
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.
11-07-2012 08:33 AM
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...
11-07-2012 09:38 AM
A little more searching found this:
which I hard coded to :
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!