Hello all!
I have the example code as below, from which I want to develop a table of contents on the left side of the pdf file without the node 'table1', then I applied the example code to my own code, however, it ends up having the node'table1', do you know what to do with it? Thanks!
Example Code:
ods proclabel 'Section 1';
data example;
set sashelp.class;
holder=1;
run;
ods document name=mydocrep(write);
proc report nowd data=example(obs=2) contents='Group 1';
define holder / noprint order;
break before holder / page contents='';
run;
ods proclabel=' ';
proc report nowd data=example(obs=4) contents='Group 2';
define holder / noprint order;
break before holder / page contents='';
run;
ods proclabel=' ';
proc report nowd data=example(obs=4) contents='Group 3';
define holder / noprint order;
break before holder / page contents='';
run;
ods document close;
proc document name=mydocrep ;
move Report#2\Report#1 to report#1;
delete Report#2;
move Report#3\Report#1 to report#1;
delete Report#3;
run;
ods pdf file="/C:/Mtest293.pdf";
replay;
run;
ods pdf close;
quit;
My Own Code:
ods proclabel 'Section 1';
%macro report(product ,title,content);
Proc report data=&product. contents=&content.
style(header)={color=black background=cornflowerblue fontweight=bold }
style(column)={just=center background=snow foreground=black fontweight=bold};
title3 j=c color=black HEIGHT=14pt BOLD &title.;
footnote3" ";
column _name_ year2017 year2016 Num_of_Variance mature2016 Num_of_Variance2 y2017 y2016 Variance ;
define _name_ / "Metrics" style(column)=data[ foreground=negfmt.];
define year2017/ "&dt_Mon." style=[foreground=negfmt.];
define year2016/ " &dt_Mon_pre." style=[foreground=negfmt.];
define Num_of_Variance/ "# of Variance" style=[foreground=negfmt. width=0.9in];
define mature2016/ "Mature &dt_Mon_pre." style=[foreground=negfmt.];
define Num_of_Variance2/ "# of Variance" style=[foreground=negfmt. width=0.9in];
define y2017/ "YTD17" style=[foreground=negfmt.];
define y2016/ " YTD16" style=[foreground=negfmt.];
define Variance/ "# of Variance" style=[foreground=negfmt. width=0.9in];
compute _name_ ;
if _name_= 'Avg Score' then call define(_row_,'style','style={background=gainsboro}');
if _name_= 'Avg ApScore' then call define(_row_,'style','style={background=gainsboro}');
endcomp;
%macro comp(arg);
compute &arg;
If _name_='App' then call define(_col_,'format','comma20.0');
If _name_='CreAR' then call define(_col_,'format','percent8.1');
if _name_= 'JuAR' then call define(_col_,'format','percent8.1');
if _name_= 'Ref % ' then call define(_col_,'format','percent8.1');
if _name_= 'Avg Score' then call define(_col_,'format','comma8.0');
if _name_= 'Avg AppScore' then call define(_col_,'format','comma8.0');
if _name_= 'Cos %' then call define(_col_,'format','percent8.1');
if _name_= 'NF%' then call define(_col_,'format','percent8.1');
if _name_= 'Uppe %' then call define(_col_,'format','percent8.1');
if _name_= 'Grad%' then call define(_col_,'format','percent8.1');
if _name_='FIC%' then call define(_col_,'format','percent8.1');
if _name_='FI%' then call define(_col_,'format','percent8.1');
if _name_='Se %' then call define(_col_,'format','percent8.1');
endcomp;
%mend common_lines;
%comp(year2016);
%comp(year2017);
%comp( Num_of_Variance);
%comp(mature2016);
%comp( Num_of_Variance2);
%comp( y2017);
%comp(y2016);
%comp( Variance);
/* */
/* ods proclabel=' '; */
%mend;
ods pdf close;
ods document name=mydocrep(write);
%report (all_dqm, " All Products" ,'group1');
ods proclabel=' ';
%report (so_dqm, "SO " , 'group2');
ods proclabel=' ';
%report (pl_dqm, "PL " , 'group3');
ods proclabel=' ';
%report (ct_dqm, "CT " ,'group4');
ods proclabel=' ';
%report (bar_dqm, "BS " ,'group5');
ods proclabel=' ';
%report (mx_dqm, "MR",'group6');
ods document close;
proc document name=mydocrep ;
move Report#2\Report#1 to report#1;
delete Report#2;
move Report#3\Report#1 to report#1;
delete Report#3;
move Report#4\Report#1 to report#1;
delete Report#4;
move Report#5\Report#1 to report#1;
delete Report#5;
move Report#6\Report#1 to report#1;
delete Report#6;
run;
ods pdf file="/C:/Mtest28993.pdf";
replay;
run;
ods pdf close;
quit;
