Preparing to Create an Aggregation Table

Set Up the Aggregation Transformation in the Process Flow Diagram

To create an aggregation table, you must first set up the Aggregation transformation in a job and then invoke one of the aggregation wizards. To set up the necessary Aggregation transformation, perform the following steps:

Locate the job that you want to contain this Aggregation transformation. From the IT Data Marts tree, navigate to the IT data mart and folder that contains the job that you want to use. Double-click the job to open it on the Diagram tab of the Job Editor window.

If you want to create a new job, see Jobs That Process IT Data.
Navigate to the Transformations tree and expand SAS IT Resource Management.
Drag and drop the Aggregation transformation onto the process flow diagram.

Note: A job can contain multiple Aggregation transformations.
Drag and drop a source table onto the process flow diagram and using the cursor, connect the table to the left side of the aggregation image.

Note: The source table is usually a staged table that was created by a SAS IT Resource Management staging transformation, but it can be any SAS table. If the input source is a view and is not associated with a library, be sure to assign a libref to the view. A libref is a name that is associated with the physical name of a SAS library. You can issue a LIBNAME assignment, which associates a libref with a view, in the public code. You can also issue it as PRE-Code on the Aggregation transformation, or as pre-assigned libraries to the SAS session that runs the job.
Right-click the aggregation image and, from the drop-down menu that is displayed, select Add Aggregation Table.
Select the type of aggregation table that you want to create. (If you click Cancel on any page of an aggregation wizard, a confirmation dialog box is displayed. If you do not want to cancel, click No.)
- Select Simple Aggregation Table to invoke the Simple Aggregation Table wizard. For information about using this wizard, see Creating an Aggregation Table with the Simple Aggregation Table Wizard.
- Select Summarized Aggregation Table to invoke the Summarized Aggregation Table wizard. For information about using this wizard, see Creating Aggregation Tables with the Summarized Aggregation Table Wizard.
- Select Aggregations through Template to invoke the Aggregations through Template wizard. This wizard enables you to choose one of the following template sources:
  
  From Supplied Template
  
  From User-Defined Template
  
  For information about using this wizard, see Creating Aggregation Tables with the Aggregation through the Template Wizard.
Note: You can create multiple summarized aggregation tables. The aggregation wizard provides a unique suffix for each table that is created.