Yes, I am going to generate separate PROC REPORTs for every row / every DSN. The reports themselves are not automated, since the the reported tables are of different structure, so I write them manually. The thing I want to be automated is the generation of headers and footnotes. All this happens within ODS PDF / ODS RTF. It looks like this: options nobyline number missing="";
ods escapechar='^';
ods listing close;
ods rtf file =
"&out\FAS_Tables_.rtf"
style = journal startpage=yes toc_data
CONTENTS=YES;
ods noproctitle;
title;
ods proclabel "Table 1.0 Subject disposition: Recruiting, Enrollment, Analyis-Set and First patient in";
title5 j=C f=Courier h=9pt 'Table 1.0 : Recruiting, Enrollment, Analyis-Set and First patient in';
*title6 j=C f=Courier h=9pt 'Subject Disposition';
footnote1 j=l f=Courier h=9pt "Reference:" ;
footnote2 j=l f=Courier h=9pt "ana_TFL_V01-00.sas &sysdate9.";
%maxpage(data=forreport_rek_enrol_FPI);
proc report data = forreport_rek_enrol_FPI nowd style(report)=[font_size=8pt font=(Courier)]
style(header)=[font_size=8pt font=(Courier)]
style(column)=[font_size=8pt font=(Courier)]
style(lines)=[font_size=8pt font=(Courier)]
contents = "" ;
column mypage group variable colTotal ;
define mypage/ order noprint ;
define group /order order = internal noprint;
define variable / display 'Variable' order=data group;
define colTotal / display '' center ;
break after group / skip;
break before mypage/ contents = "" page;
compute after _page_ ;
_page+1;
line @60 'Page' _page " of &maxpage";
endcomp;
run;
... Is this helpful? Thank you!
... View more