Date: Wed, 24 Sep 2008 16:14:01 -0400
Reply-To: SAS_learner <proccontents@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: SAS_learner <proccontents@GMAIL.COM>
Subject: Re: Reporting Question
Content-Type: text/plain; charset=ISO-8859-1
I have seen people doing it in the PDF. The way they do it is convert the
Individual Rtf files into PDF files and then merge it one big document. Last
time I tried very similar thing did little of googling found out there are
some VB scripts out there which would help you in getting what you wanted .
I could not use them as I do not have admin rights to download scripts that
are not validated.
Well I have seen you tried the suggestion by Lou and it would mess up the
page numbers. I think it is something to do with the internal way how RTF
stores or something to do RTF.
Any way if you still want to do it then there is way around it. But it
might be need little bit of extra programming . In the Past I have
generated two different tables one after or other in same rtf ( related
though ) . The technique is to have Couple of proc reports inside one ODS
statement and have one name at ods output some thing like this.
Proc Copy in = sasuser out = work ;
select Acities admit airports Allemps ;
%let dir1 = L:\ ;
ods rtf file = "&dir1.test.RTF" ;
Proc Report data = Acities nowd missing headline headskip split='?'
Column city ;
Title4 "Report of Acities" ;
Proc Report data = admit nowd missing headline headskip split='?'
Column name ;
Title4 "Report of admit" ;
Proc Report data = airports nowd missing headline headskip split='?'
Column city ;
Title4 "Report of airports " ;
Proc Report data =Allemps nowd missing headline headskip split='?'
Column Location ;
Title4 "Report of Allemps " ;
ods _ALL_ close;
This Technique needs you output all your table datasets out with a unique
name and have one big fat proc report SAS program and have the Proc Reports
inside that .
I hope this technique works for you and do please let me know if it works as
I never tried on tables more than three of them.
There may issuses related to size of the Rtf too. Some body told me that
once the Rtf grows in size Word take too much of the time to open it or may
fail altogether to open it.
Well good luck in your search and hope my suggestions works for you or some
body else ( Sas gurus ) might have an eligent solution for this.