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 View
Basic Properties from the menu
bar.
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 ToolsOptions from the desktop menu
bar and deselect the row count option on the General tab.
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.
|
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.
|
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.
|
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.
|
Category
|
Icon
|
Description
|
|---|---|---|
|
Column
|
 |
Metadata for
a character column.
|
 |
Metadata for
a numeric column.
|
|
|
Index
|
 |
Metadata for
an index.
|
|
Key
|
 |
Metadata for a foreign key
|
 |
Metadata for a primary key or a unique key.
|
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 16, 2018