Properties Windows :: SAS(R) Data Integration Studio 4.9: User's Guide

Basic Properties

The Basic Properties pane is an optional pane that can be displayed on the right side of the desktop. It displays the main attributes of an object that is selected in a tree view. To display or hide this pane, select or deselect View

Basic Properties from the menu bar.

Note: If you have not selected a default SAS Application Server, and you select a table in a tree view, you are prompted to select a SAS Application Server so that the Basic Properties pane can display a row count for the table. To avoid this prompt, you can select a default SAS Application Server for SAS Data Integration Studio, or you can hide the Basic Properties pane. You can also select Tools

Options from the desktop menu bar and deselect the row count option on the General tab.

Job Properties

The job properties window enables you to view or update the metadata for a SAS Data Integration Studio job. One way to display this window is to right-click a job in the Folders tree or Inventory tree, and click Properties in the pop-up menu. The next table describes the purpose of each tab in a job properties window. For more information about each tab, see the Help for that tab.

Tabs in a Job Properties Window
Tab	Description
General	Enables you to enter general information that identifies, describes, and locates the job.
Code	Enables you to review and modify the code that is generated for the job.
Precode and Postcode	Enables you review and modify user-written code that is inserted at the beginning or end of the job.
Status Handing	Enables you to review and modify status handling conditions and actions for the job. (Some transformations have this tab as well.)
Parameters	Enables you to review and modify parameters for the job.
Options	Enables you to review and modify options for the job.
Notes	Enables you to review and modify notes for the job.
Extended Attributes	Enables you to review and modify extended attributes for the job.
Authorization	Enables you to review and modify metadata access settings for the job.

Transformation Properties

The transformation properties window enables you to view or update the metadata for a transformation in a SAS Data Integration Studio job. One way to display this window is to open a job in the Job Editor, right-click a transformation on the Diagram tab, and click Properties in the pop-up menu. The property window for most transformations has one or more tabs that are unique to that transformation. The following table describes the purpose of the common tabs for a transformation. For more information about each tab, see the Help for that tab.

Common Tabs in a Transformation Properties Window
Tab	Description
General	Enables you to enter general information that identifies and describes the transformation.
Mappings	Enables you to review and modify the mappings for the transformation.
Options	Enables you to review and modify options for the transformation.
Table Options	Enables you to review and modify table options for the transformation.
Code	Enables you to review and modify the code that is generated for the transformation.
Precode and Postcode	Enables you review and modify user-written code that is inserted at the beginning or end of the transformation.
Parameters	Enables you to review and modify parameters for the transformation.
Notes	Enables you to review and modify notes for the transformation.
Extended Attributes	Enables you to review and modify extended attributes for the transformation.

Table Properties

The table properties window enables you to view or update the metadata for the table. One way to display this window is to right-click a table in the Folders tree or the Job Editor and click Properties in the pop-up menu. The next table describes the purpose of each tab in a table properties window. For more information about each tab, see the Help for that tab.

Tabs in a Table Properties Window
Tab	Description
General	Enables you to enter general information that identifies and describes the table.
Columns	Enables you to maintain column metadata.
Indexes	Enables you to review, add, and modify indexes on table columns.
Keys	Enables you to review, add, and modify key columns.
Parameters	Enables you to review and modify parameters for the table.
Physical Storage	Enables you to specify the format and location of a table.
Options	Enables you to review and modify options for the table.
Notes	Enables you to review and modify notes for the table.
Extended Attributes	Enables you to review and modify extended attributes for the table.
Authorization	Enables you to review and modify metadata access settings for the table.

The following table lists icons that represent columns and related attributes. These icons are displayed in the Mappings tab, Columns tab, the Indexes tab, or the Keys tab in the property window for tables.

Icons and Attributes
Category	Icon	Description
Column		Metadata for a character column.
Column		Metadata for a numeric column.
Index		Metadata for an index.
Key		Metadata for a foreign key
Key		Metadata for a primary key or a unique key.