topic Re: Footnote and title in ods word in ODS and Base Reporting

Footnote and title in ods word

Sisa — Mon, 14 Oct 2019 15:09:54 GMT

I want a title in the beginning of the word file, and a footnote in the end of the wordfile (not inside the graph borders). When I use the code below, there is no title produced (and no errors occur). I could not find the code for footnote. SAS 9.4 TS1M6

*Define mystyle;
proc template;
	define style mystyle;
	parent = styles.word;
	style body from body / background=white;
	style header from header/ background=white;

    style fonts /                                                           
         'TitleFont2' = ("Albany AMT",2,bold)                                                                
         'TitleFont' = ("Albany AMT",3,bold)                                                                    
         'StrongFont' = ("Albany AMT",2,bold)                                                                
         'EmphasisFont' = ("Albany AMT",2,italic)                                                              
         'FixedFont' = ("Albany AMT",2)                             
         'BatchFixedFont' = ("Albany AMT",2)                                                                   
         'FixedHeadingFont' = ("Albany AMT",2)           
         'FixedStrongFont' = ("Albany AMT",2,bold)       
         'FixedEmphasisFont' = ("Albany AMT",2,italic)   
         'headingEmphasisFont' = ("Albany AMT",2,bold italic)       
         'headingFont' = ("Albany AMT",2,bold)                                                                
         'docFont' = ("Albany AMT",2);     
      class GraphFonts /                                                      
         'GraphDataFont' = ("Albany AMT",7pt)               
         'GraphUnicodeFont' = ("Albany AMT",9pt)                  
         'GraphValueFont' = ("Albany AMT",9pt)              
         'GraphLabel2Font' = ("Albany AMT",10pt)            
         'GraphLabelFont' = ("Albany AMT",10pt,bold)        
         'GraphFootnoteFont' = ("Albany AMT",10pt,italic)   
         'GraphTitleFont' = ("Albany AMT",11pt,bold)        
         'GraphTitle1Font' = ("Albany AMT",14pt,bold)       
         'GraphAnnoFont' = ("Albany AMT",10pt);
	end;
run;

data cc8;
   input ch 1-4 arm $ lbtest $;
   datalines;  
0.28 TrtA ALP
0.30 TrtA ALP
0.33 TrtA ALP
0.24 TrtA ALP
0.45 TrtA ALP
0.54 TrtA ALP
0.58 TrtB ALP
0.30 TrtB ALP
0.33 TrtB ALP
0.26 TrtB ALP
0.45 TrtB ALP
0.34 TrtB ALP
;
run;

option nonumber nodate;

ods word file="H:\Boxplots.docx" style=mystyle title='Boxplots of clinical chemistry';
proc sgplot data=cc8;
 	vbox ch /group=arm; label ch="Change from baseline (unit)"; refline 0;
run;
ods _all_ close;

Re: Footnote and title in ods word

Cynthia_sas — Mon, 14 Oct 2019 20:21:38 GMT

Hi:

The ODS style template changes the characteristics of the TITLE (or FOOTNOTE) that you insert into OUTPUT using a TITLE or FOOTNOTE statement.

What you show in your code is a TITLE option on the ODS invocation statement -- that is NOT controlled by the style template. As you can see below, the TITLE="title string" that you place on the ODS statement goes into the document metadata -- as shown below:

Please use a regular TITLE statement:

title 'This is my title';

immediately above your SGPLOT statement or between the PROC SGPLOT and the RUN statements.

Hope this helps,

cynthia

Re: Footnote and title in ods word

MichaelL_SAS — Mon, 14 Oct 2019 20:31:24 GMT

Looking at the documentation the ODS WORD statement, the title specified in the TITLE= option appears in the document properties. Using the example you provided I see

I think instead you might want to use the TITLE and FOOTNOTE statements along with the NOGTITLE and NOGFOOTNOTE options in the ODS WORD statement to move the title and footnote out of the graph borders.

So for example something like:

ods word file="H:\Boxplots.docx" style=mystyle nogtitle nogfootnote;
title 'Boxplots of clinical chemistry';
footnote 'footnote text';
proc sgplot data=cc8;
 	vbox ch /group=arm; label ch="Change from baseline (unit)"; refline 0;
run;
ods _all_ close;

Re: Footnote and title in ods word

Sisa — Tue, 15 Oct 2019 13:26:41 GMT

Thank you both. Is it possible to have a title both inside each graph window and one for the whole document? And the same for footnotes.

Re: Footnote and title in ods word

MichaelL_SAS — Tue, 15 Oct 2019 13:47:25 GMT

Yes, here is an example in a previous communities post that creates footnotes and titles both in and outside of the graph walls. The example uses the SGANNO= option in PROC SGPLOT to add a title and a footnote within the plot window using an annotation data set.

For more examples of using annotation, there is this SAS Global Forum paper or Chapter 4 in this book.