Properties Windows

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 Viewthen selectBasic 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 Toolsthen selectOptions 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
Character icon
Metadata for a character column.
Numeric icon
Metadata for a numeric column.
Index
Index icon
Metadata for an index.
Key
Foreign Key icon
Metadata for a foreign key
Unique Key icon
Metadata for a primary key or a unique key.
Last updated: January 16, 2018