TEMPLATE Procedure: Creating Table Templates
- Syntax
Procedure SyntaxCELLSTYLE AS StatementCOLUMN StatementCOMPUTE AS StatementDEFINE StatementDEFINE COLUMN StatementDEFINE FOOTER StatementDEFINE HEADER StatementDEFINE TABLE StatementDYNAMIC StatementEDIT StatementEND StatementFOOTER StatementHEADER StatementMVAR StatementNMVAR StatementNOTES StatementTEXT StatementTEXT2 StatementTEXT3 StatementTRANSLATE INTO Statement - Overview
- Concepts
- Using
- Examples Editing a Table Template That a SAS Procedure UsesComparing the EDIT Statement to the DEFINE TABLE StatementCreating a New Table Template Setting the Style Element for Cells Based on Their ValuesSetting the Style Element for a Specific Column, Row, and CellCreating Master TemplatesTable Header and Footer Border Formatting
Syntax
PROC TEMPLATE;
EDIT template-path-1 <AS template-path-2> < /
STORE=libref.template-store > ;
statements-and-attributes
END;
DEFINE COLUMN column-path | Base.Template.Column
< /
STORE=libref.template-store>;
statements-and-attributes
END;
DEFINE FOOTER footer-path | Base.Template.Footer
< / STORE=libref.template-store>;
statements-and-attributes
END;
DEFINE TABLE table-path | Base.Template.Table
</ STORE=libref.template-store>;
statements-and-attributes
END;
Table of Procedure Tasks
| Statement | Task | Example |
|---|---|---|
| CELLSTYLE AS Statement | Set the style element of the cells in the table or column according to the values of the variables | Ex. 5, Ex. 6 |
| COLUMN Statement | Declare a symbol as a column in the table and specify the order of the columns | Ex. 2 |
| COMPUTE AS Statement | Compute values for a column that is not in the data component, or modify the values of a column that is in the data component | |
| DEFINE Statement | Create a template inside a table template | Ex. 2, Ex. 3, Ex. 7 |
| DEFINE COLUMN Statement | Create a template for a column | Ex. 4, Ex. 5, Ex. 6 |
| DEFINE FOOTER Statement | Create a template for a table footer | Ex. 3 |
| DEFINE HEADER Statement | Create a template for a table header or a header inside a column template | Ex. 5, Ex. 6 |
| DEFINE TABLE Statement | Create a table template | Ex. 4, Ex. 5, Ex. 6 |
| DYNAMIC Statement | Define a symbol that references a value that the data component supplies from the procedure or DATA step | Ex. 2 |
| EDIT Statement | Edit an existing template for a table, column, header, or footer | Ex. 1, Ex. 2, Ex. 7 |
| END Statement | End the table template, header template, column template, or footer template | |
| FOOTER Statement | Declare a symbol as a footer in the table and specify the order of the footers | Ex. 7 |
| HEADER Statement | Declare a symbol as a header in the table and specify the order of the headers | Ex. 3, Ex. 7 |
| MVAR Statement | Define a symbol that references a macro variable, the value of which is treated as a string | Ex. 3 |
| NMVAR Statement | Define a symbol that references a macro variable, the value of which is treated as a number | |
| NOTES Statement | Provide information about the table, header, column, or footer | Ex. 2 |
| TEXT Statement | Specify the text of a header, footer, or the label of a variable in an output data set | Ex. 5 |
| TEXT2 Statement | Provide an alternative header or footer to use in the LISTING output if the header or footer that is provided by the TEXT statement is too long | |
| TEXT3 Statement | Provide an alternative header or footer to use in the LISTING output if the header or footer that is provided by the TEXT2 statement is too long | |
| TRANSLATE INTO Statement | Translate the specified numeric values to other values |