Date:         Wed, 19 May 2004 09:23:43 -0700
Reply-To:     Jeff Morison <jmt_mtf@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jeff Morison <jmt_mtf@YAHOO.COM>
Subject:      proc report output to PDF
Content-Type: text/plain; charset=us-ascii

Hi:

  I am trying to create a pdf file of my proc report
output.  The following code does create the pdf file,
but has some problems.

1.  The split charcter is not working in the column
header.

2.  The PAGE X OF X numbering is not working.
    For this first I am writing the output to an
output file and then counting the # of pages and
displaying it in the title which works in SAS output
file but not in pdf file.

How do I create the pdf file of the proc report output
as it is, simple and plain as it appears in the SAS
OUTPUT window without any fancy formatting and
background colors, retaing the spacing and page
numbering, Can someone please provide any feedback?.
Thanks,
Jeff.

  ods pdf file="&PDFFILE" notoc;
  proc printto print="&outfile" new;
  options nonumber missing=' ' nodate ls=126 ps=41;
  proc report data=alltran nowd headskip split='*'
missing spacing=4;

columns visitnum statistic ('Treatment Group*__* '
trt1 trt2 trt3);

define visitnum  /group order=internal format=visit.
width=8 'Visit*__' center;

define statistic                  /width=15
format=$cat. 'Statistic*__' center;

define trt1                       /width=14
format=$14. "Placebo*(N=&N1)*__" center;

define trt2                       /width=14
format=$14. "1% Lidocaine*(N=&N2)*__" center;

define trt3                       /width=14
format=$14. "4% Lidocaine*(N=&N3)*__" center;

     break after visitnum /skip;

     title1 "&title2";
     title2 "Table A1";
     title3 'Time to Deliver Study Drug in Minutes by
Nebulizer';
     title4 '(PAGE X OF X)';
     title5 ' ';
     footnote1 "&source";
  run;

  proc printto;
  run;

 *** To call the rptpage macro to count the # of pages
and display in the report title as Page X of Y ***;

%rptpage(&OUTFILE,$126.);

 ods pdf close;







__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/