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

Overview

You can use the User Columns tab in the properties window for the Clickstream Parse transformation when you want to define your own columns. These user columns can be used to store interim values during the parse process or they can be added to the target table on the Target Table tab.

Specifically, the users columns often serve the following purposes:

holding values determined by user-defined rules on the Rules tab
storing values from clickstream parameters defined on the Clickstream Parameters tab.

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 tasks to create a new user column:

Click New column to add a row to the user columns table.
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 onto 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, such as copying, importing, or modifying a parameter, see the Help for the User Columns tab.