Creating a Column Data Source

A column data source is a column in an existing SAS table that is accessible to users through applications such as the SAS Information Delivery Portal. 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. The portal uses the LDAP definition to access the column. For general instructions, see Using IT Administrator.

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 New 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.