SAS 9.1.3 Integration Technologies » Administrator's Guide (LDAP Version)


SAS Data Sources
Library Data
Column Data
Table Data
Data Sources

Creating a Column Data Source

A column data source is a column in an existing SAS table that is accessible to users through client applications. You must create a data source definition for the column's table before you create the column definition.

The SAS Integration Technologies Administrator provides a graphical user interface that allows you to create an LDAP object definition for a column. Client applications can then use the LDAP definition to access the column.

To add a new column data source using IT Administrator:

  1. Open IT Administrator.

  2. Select the SAS Data Sources button in the Manager Bar.

  3. Select the Tables folder in the tree view.

  4. Select the definition for the table that contains the column you want to use as a data source.

  5. Select File arrow New arrow Column. The New Column window appears and requests that you enter property information for the new column.

  6. Enter a name and description for the column. The name identifies the column in the tree view, and the description is visible when the object properties are viewed.

  7. In the Column fields, you must enter the following information:

    Name
    Enter the name of the column as it is identified in the SAS table. The column must already exist and must use the same name as the one that is specified in this field.

    Type
    Enter the column type - either N (numeric) or C (character).

    Maximum Length
    Enter the maximum specified length for values in the column.


  8. Enter values for any of the other Column fields as needed. You can find information about the values that are required in each field by selecting the Help button in the New Column window.

  9. When you are finished entering information in the fields, select OK. The new column definition appears in the tree view.