Managing User Columns :: SAS(R) Data Surveyor for Clickstream Data 2.2: User's Guide

Overview

Sometimes an input column from the Web log does not have a matching Clickstream Parse Input Column. In that case, you can use the User Columns tab in the properties window for the Clickstream Log transformation to add a user-defined column. The new column appears in the output table for the Clickstream Log transformation and is available to Clickstream transformations later in the process flow for the job.

Each row in the table on the User Columns tab contains the metadata for a user column.

The row for each user column consists of the following columns:

Name

specifies the name of the column in the table.

Description

specifies a description for the contents of the column.

Type

specifies the data type of the column.

Length

specifies the length of the column.

Format

specifies the SAS format used (if needed) to specify formats for the selected column.

Is Nullable

if present, indicates whether a column can contain null or missing values.

Perform the following tasks:

Create a New User Column

Perform the following steps to create a new user column:

Click the New column button in the toolbar to add a row to the table on the User Columns tab.
Enter appropriate values in the Name, Description, Type, Length, Format, and Is Nullable columns.

Reuse User-Defined Columns in Other Clickstream Jobs

The User Columns tab lists the metadata for any user-defined output columns that have been defined for the Clickstream Log transformation or the Clickstream Parse transformation. You cannot export user-defined columns from the User Columns tab and then import them into other jobs. However, you can use the background pop-up menu on any output table in the job that contains the user columns and then register the output table. Any user-defined columns in these tables can then be imported into the User Columns tab, using the Import Columns option on that tab.

Other Tasks for Managing User Columns

For information about other ways to manage user columns, see the Help for the User Columns tab.