Creating an Aggregation Table with the Simple Aggregation Table Wizard

To create an aggregation table with the Simple Aggregation Table wizard, respond to the wizard's prompts.

To enter general information about the table, see How to Enter General Information about the Aggregation Table.
If this aggregation table is the first target table that is specified for this Aggregation transformation, an additional page of the wizard opens. This page prompts you for the physical target location and for information about the SAS library where the data will be stored. For information about specifying a library, see How to Specify Library Information.
Filters can limit the amount of data that is input to an aggregation table. On the page of the wizard that is called Select filter and column for data duplication, you can specify a filter. For information, see How to Select a Filter.
On the Specify aging page, you can specify aging and purging criteria. For information, see Specify Aging.
On the Specify target columns page, you can specify the columns from the source table that are to be included in the target aggregation table. To select columns for the target table, highlight the columns in the Available source columns panel and then click the right arrow to move those columns into the Selected source columns.

Specify Target Columns Page of the Simple Aggregation Table Wizard

You can select the entire list of available source columns by clicking the double right arrow. Back arrows can be used to deselect one, several, or all columns.

If aging is to be performed for this simple aggregation table, then the selected aging column is automatically added to this list. It cannot be deleted while it is still in use as the aging column.
On the Specify column details page, you can modify the Target Column Name and Target Column Label fields for any of the source columns that you are including in the target aggregation table. To do so, enter the new value in the field.

To modify the format, double-click in the field and select the new format from the drop-down list.
On the Join columns page, you can specify columns from other aggregation tables in this Aggregation transformation to join with columns in this target table. For information, see Specify Join Columns.

Note: The Join Columns page is available from the Simple Aggregation wizard only if there are columns from separate target tables that are eligible for joining.

Note: If you do not want to specify a computed column for this aggregation table, click Finish, which updates the Aggregation transformation with this new aggregation target table and returns you to the process flow diagram.
On the Computed columns page, you can create, modify, or delete computed columns.

For information about how to add, modify, or delete computed columns, see Specify Computed Columns.
The final page of the wizard displays the details for the simple aggregation table that you specified. If you are satisfied with your choices, click Finish. Click OK to return to the process flow diagram.