To view the Measures code, double-click Measures. The Measures template opens in
the Template Browser window. You can then copy and paste the code into the Editor
window for customization.
Output 34.3 Measure Templates That Are Supplied by SAS
You can create your own table template or modify an existing one by using the
TEMPLATE procedure. The following is a simplified form of the TEMPLATE
procedure:
PROC TEMPLATE;DEFINE table-definition;HEADER header(s);COLUMN
column(s);END;
The DEFINE statement creates the table template that serves as the template for writing
the output. The HEADER statement specifies the order of the headings, and the
COLUMN statement specifies the order of the columns. The arguments in each of these
statements point to routines in the program that format the output. The END statement
ends the table template.
The following example shows how to use PROC TEMPLATE to create customized
HTML and PDF output. You can first copy the SAS template code that is supplied by
SAS using the method described in Output 34.3 on page 672. In this example, the SAS
672 Chapter 34 Understanding and Customizing SAS Output: The Output Delivery System (ODS)
program creates a customized table template for the Basic Measures output table from
PROC UNIVARIATE. The following customized version shows that
the “Measures of Variability” section precedes the “Measures of Location” section
column headings are modified
font colors are modifies
statistics are displayed in a bold, italic font with a 7.3 format, and a specific font
color.
Create the new template.
1 options nodate nonumber;
2 proc template;
3 define table base.univariate.Measures;
4 header h1 h2 h3;
5 column VarMeasure VarValue LocMeasure LocValue;
6 define h1;
text "Basic Statistical Measures";
style=data{color=orange fontstyle=italic};
spill_margin=on;
space=1;
end;
6 define h2;
text "Measures of Variability";
start=VarMeasure;
end=VarValue;
end;
6 define h3;
text "Measures of Location";
start=LocMeasure;
end=LocValue;
end;
7 define LocMeasure;
print_headers=off;
glue=2;
space=3;
style=rowheader;
end;
7 define LocValue;
print_headers=off;
space=5;
format=7.3;
style=data{font_style=italic font_weight=bold color=red};
end;
7 define VarMeasure;
print_headers=off;
glue=2;
space=3;
Customizing ODS Output 673
style=rowheader;
style=data{font_style=italic font_weight=bold color=purple};
end;
7 define VarValue;
print_headers=off;
format=7.3;
style=data{font_style=italic font_weight=bold color=blue};
end;
8 end;
9 run;
The following list corresponds to the numbered items in the preceding program:
1
The NODATE and NONUMBER options affect the Printer output. None of the
options affects the HTML output.
2
PROC TEMPLATE begins the procedure for creating a table.
3
The DEFINE statement creates the table template base.univariate.Measures in
SASUSER.
The base.univariate.Measures table template that SAS provides is stored in a
template store in the SASHELP library. (See Output 34.2 on page 670.)
4
The HEADER statement determines the order in which the table template uses the
headings, which are defined later in the program.
5
The COLUMN statement determines the order in which the variables appear. PROC
UNIVARIATE names the variables.
6
These DEFINE blocks define the three headings and specify the text to use for each
heading. By default, a heading spans all columns. This is the case for H1. H2 spans
the variables VarMeasure and VarValue. H3 spans LocMeasure and LocValue.
7
These DEFINE blocks specify characteristics for each of the four variables. They use
FORMAT= to specify a format of 7.3 for LocValue and VarValue. They also use
STYLE= to specify a bold, italic font for these two variables. The STYLE= option
does not affect the LISTING output.
8
The END statement ends the table template.
9
The RUN statement executes the procedure.
To view the table template that PROC TEMPLATE created, in the Templates window,
select Sasuser.Templat ð Base ð Univariate. By default, ODS searches for a table
template in SASUSER before SASHELP. When PROC UNIVARIATE calls for a table
definition by this name, ODS uses the one from SASUSER.
674 Chapter 34 Understanding and Customizing SAS Output: The Output Delivery System (ODS)
Output 34.4 User Created PROC UNIVARIATE Table Template
Create the output that uses the new template.
1 ods select BasicMeasures;
options nodate nonumber;
proc sort data=sashelp.prdsale out=prdsale;
by Country;
run;
2 ods html file='SalesFig–body.htm'
contents='SalesFig–contents.htm'
page='SalesFig–page.htm'
frame='SalesFig–frame.htm';
3 ods pdf file='odspdf_output_custom2.pdf' ;
title 'Actual Product Sales';
title2 '(millions of dollars)';
Customizing ODS Output 675

Get Step-by-Step Programming with Base SAS 9.4, Second Edition, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.