Note for Program 2: Building a Custom Table Template for the TopN Report

Create the table element Table_Footer. The DEFINE statement and its substatement and attribute define Table_Footer. The FOOTER argument declares Table_Footer as a footer. (Compare this approach with the creation of the headers. You could use a FOOTER statement instead of the FOOTER argument in the DEFINE statement.)

The TEXT statement specifies the text of the footer. When ODS binds the data component to the table template (in the DATA step that follows), it will resolve the value of the macro variable SYSDATE9. The table template itself contains a reference to the macro variable. The SPLIT= attribute specifies the asterisk as the split character. This prevents the header from splitting at the open parenthesis. If no split character is specified, then ODS interprets the nonalphabetic, leading character as the split character (see the discussion of text-specification(s) in TEXT Statement.) Alternatively, place a space character before the open parenthesis.

The STYLE= attribute alters the style element that displays the table footer. The style element Header is defined in the default style, Syles.Default. (For information on viewing a style, see Viewing the Contents of a Style.) In this case, the STYLE= attribute specifies a small font size. All other attributes that are included in Footer remain in effect. This attribute affects only the HTML output.

The END statement ends the footer template.

   define footer table_footer;
      text "(report generated on " sysdate9 ")";
      split="*";
      style=header{fontsize=2};
   end;