TABULATE Procedure
- Syntax
- Overview
- Concepts
- Using
- Results
- Examples Creating a Basic Two-Dimensional TableSpecifying Class Variable Combinations to Appear in a TableUsing Preloaded Formats with Class VariablesUsing Multilabel FormatsCustomizing Row and Column HeadingsSummarizing Information with the Universal Class Variable ALLEliminating Row HeadingsIndenting Row Headings and Eliminating Horizontal SeparatorsCreating Multipage TablesReporting on Multiple-Response Survey DataReporting on Multiple-Choice Survey DataCalculating Various Percentage StatisticsUsing Denominator Definitions to Display Basic Frequency Counts and PercentagesSpecifying Style Elements for ODS OutputStyle PrecedenceNOCELLMERGE Option
- References
BY Statement
Creates a separate table on a separate page for
each BY group.
| See: | BY |
Syntax
Required Argument
- variable
-
specifies the variable that the procedure uses to form BY groups. You can specify more than one variable. If you do not use the NOTSORTED option in the BY statement, then the observations in the data set must either be sorted by all the variables that you specify, or they must be indexed appropriately. Variables in a BY statement are called BY variables.
Optional Arguments
- DESCENDING
-
specifies that the observations are sorted in descending order by the variable that immediately follows the word DESCENDING in the BY statement.
- NOTSORTED
-
specifies that observations are not necessarily sorted in alphabetic or numeric order. For example, the observations are grouped in chronological order.The requirement for ordering or indexing observations according to the values of BY variables is suspended for BY-group processing when you use the NOTSORTED option. In fact, the procedure does not use an index if you specify NOTSORTED. The procedure defines a BY group as a set of contiguous observations that have the same values for all BY variables. If observations with the same values for the BY variables are not contiguous, then the procedure treats each contiguous set as a separate BY group.