Previous Page | Next Page

Maintaining Data Tables

Overview

This chapter assumes that you have evaluated the different detail data stores available in SAS/Warehouse Administrator, as described in Detail Data Stores, and have chosen to create Data Tables. SAS/Warehouse Administrator provides the Data Table as a multipurpose data store, providing flexibility and usability because of few restrictions regarding hierarchical placement and types of input sources. In SAS/Warehouse Administrator, the following objects are provided for multiple purposes:

Data Group

is a multipurpose, simple grouping element that allows you to organize Data Tables, other Data Groups, and Information Marts. You can add a Data Group to a Warehouse, Subject, or another Data Group.

Data Table

is a metadata record that specifies a SAS table or view or a DBMS table or view that can serve multiple purposes. You can use Data Tables as intermediate data stores (such as look-up tables), detail data stores, summary data stores (if you write your own summary code and register it as the Load Step for the Data Table), or tables that hold information that does not fit anywhere else. You can add a Data Table to a Data Group only.

Note:   You can also store detail data in Detail Tables. However, Data Tables are more multipurpose. Data Table metadata is the same as Detail Table metadata, except that it includes the SAS code (such as a VIEWTABLE statement) used to read the Data Table when you open it from a data utility.  [cautionend]

In general, to maintain Data Tables:

  1. Define the properties for the Data Group.

  2. Define the properties for the Data Table(s).

  3. Define a Process Editor Job that includes the data preparation processes, which prepares the data to be loaded into the Data Tables, and the Load Step, which defines the steps to load the Data Tables.

  4. Execute the Job.

  5. Verify that the Data Tables are loaded; that is, check logs, use the data utilities, and so on.

Note:   The basic steps for creating a Data Group and a Data Table are described in the online Help. To display the relevant online Help, in the SAS System Help contents, select Help on SAS Software Products [arrow] Using SAS/Warehouse Administrator Software [arrow] Defining Detail Data Stores [arrow] Maintaining Data Tables In addition, you can display Help for most SAS/Warehouse Administrator windows by selecting the Help button on the window.   [cautionend]

Previous Page | Next Page | Top of Page

Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.