Maintaining Data Tables

Example: Creating a Data Group

The Data Group is a simple grouping element that you create to group a variety of data stores, which include Data Tables. This example creates a Data Group to group related Data Tables.

Note: The following explanations describe the metadata and methods used to achieve the desired results; it is assumed that the appropriate Data Warehouse Environment, Data Warehouse, and Subject exist. [cautionend]

Define Data Group Properties

In the SAS/Warehouse Administrator Explorer, position the cursor on the Subject, for example, Toy Sales, click the right mouse button, select Add Item, and then Data Group. In the Explorer window, a new Data Group is added under the Subject as follows:

[untitled graphic]

To update the default metadata for the Data Group, position the cursor on its icon, click the right mouse button, and select Properties. The Data Group Properties window displays for you to enter the appropriate information.

General Tab

specifies the group name, for example, Intermediate Tables Data Group, a description, an owner, and an administrator.

[untitled graphic]

The next section describes how to create a Data Table to add to the Data Group.

Top of Page