The Aggregation transformation
provides a graphical user interface for the purpose of accumulating
data. The Aggregation transformation is invoked from within a job.
Right-clicking the transformation provides access to its properties
and to various other functions such as creating an aggregation table
by means of aggregation wizards.
SAS IT Resource Management
supports two types of aggregation tables:
-
Summarized aggregation tables:
Summarized aggregation
tables consist of data from the source table that is summarized in
accordance with the rules that are specified in the Aggregation transformation.
Summarized aggregation tables also include statistics, percentiles,
moving statistics, and more that are calculated and stored for the
categories of data that you specify. By means of the summarized aggregation
wizard, the Aggregation transformation enables you to do the following:
-
specify the name, table name and
description of the table
-
define filters to limit the input
data
-
specify if and how the data should
be aged
-
assign source columns as class
or ID columns
-
define statistics and percentiles
-
calculate the percent change for
statistic, and percentile columns
-
-
generate ranks on all columns or
across specified class columns
-
-
generate computed columns
-
modify column labels and formats
-
Simple aggregation tables:
Simple aggregation
tables consist of data from the source table that is simply appended
to the target table. Like summarized aggregations, simple aggregations
support aging, join columns, and computed columns. Simple aggregations
are analogous to the detail tables of the performance data warehouse
(PDB) in SAS IT Resource Management 2.7.