The SAS Output Delivery System and reporting techniques

How to remove the node'Table' out of pdf bookmark?

Reply
Contributor
Posts: 74

How to remove the node'Table' out of pdf bookmark?

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;

SAS Super FREQ
Posts: 8,645

Re: How to remove the node'Table' out of pdf bookmark?

Hi:
It appears that you are using the technique outlined in this Tech Support note: http://support.sas.com/kb/31/278.html -- if the solution provided in the note does not work for you, then my suggestion is that you open a track with Tech Support for more in-depth help.

cynthia
Post a Question
Discussion Stats
  • 1 reply
  • 63 views
  • 0 likes
  • 2 in conversation