Specifying Browse and Edit Options for Tables and External Files

Problem

You want to set options that control how tables and external files are processed in the browse and edit modes in the View Data window.

Solution

You can use the View Data tab in the Options window to specify options for the View Data window. (The Options menu is available on the Tools menu on the SAS Data Integration Studio menu bar.) The options that you set on the View Data tab are applied globally. The tab is divided into the General group box, the Column Headers group box, the Format group box, the Search group box, and the Editing group box.

Tasks

Set General Options

The General group box contains the following items:

General Options

Option	Description
Clear Query Options when refreshing	Clears any options that you set on the query when you refresh the data.
Prompt for long-running navigation operation	Determines whether the user is prompted to decide whether the View Data query should proceed with a long-running navigation operation. If this option is selected, the prompt is displayed whenever the row count of the table is either not known or greater than 100,000. If the option is deselected, the navigation operation proceeds without the warning prompt.

Set Column Heading Options

The Column Headers group box contains the following items:

Column Headings Options

Option	Description
Show column name in column header	Displays physical column names in the column headings.
Show column description in column header	Displays optional descriptions in the column headings.
Show column metadata name in column header	Displays optional column metadata names in the column headings. This metadata can be entered in some SAS Business Intelligence applications, such as the SAS Information Mapping Studio.

Note: You can display any combination of column metadata, SAS column names, and descriptions in the column headings by selecting the combination of check boxes that are required to get the result that you want.

Set Format Options

The Format group box contains the following items:

Format Options

Option	Description
Apply formats	When selected, displays formatted data in the View Data window. This option applies the permanent formats that are specified for the data when the data set is created. Deselect the check box to view unformatted data in the View Data window.
Apply metadata formats	When selected, uses metadata formats for formatted data that is displayed in the View Data window. These formats are specified in the metadata for the data set.

Set Search Options

The Search group box contains the following items:

Search Options

Option	Description
Recently specified search string (entries)	Specifies the number of recently searched strings that are displayed when you click the drop-down menu in the Search for field.
Ignore invalid column names	When selected, ignores any invalid column names that are entered into the search.

Set Editing Options

The Editing group box contains the following items:

Editing Options

Option	Description
Allow editing of SCD2 tables without prompting	Determines whether a warning dialog box that states that edits to Slowly Changing Dimension (SCD) tables causes the SCD to no longer be valid is displayed.
Always delete rows without prompting	Determines whether a warning dialog box is displayed before rows are deleted.
On multi-row operation errors	When one or more errors occur in a multi-row editing operation, determines whether the user is prompted, errors are ignored and the operation is continued, or the operation is canceled.
Default date format	Default date values are returned as yyyy-MM-dd
Default datetime format	Default datetime values are returned as yyyy-MM-dd hh:mm:ss.SSS