The edit
mode of the
View Data window contains a group
of functions that enable you to customize how the data in the window
is displayed. These functions are controlled by the view data toolbar,
as shown in the following display.
Perform
the tasks that are listed in the following table to edit the data
displayed:
Edit Functions in the View Data Window
|
|
|
Perform the following steps:
-
Enter a row number in the Go to row field and click Go to specify the number of the first row that is displayed in the
table.
-
Click Go to first row to navigate to the first row of data in the View Data window.
-
Click Go to last row to navigate to the last row of data in the View Data window.
|
Select a View Data window mode
|
Perform the following steps:
-
Click Switch to browse
mode to switch to the browse mode.
-
Click Switch to edit
mode to switch to the edit mode.
Note that the Switch to browse mode and Switch to edit mode buttons are displayed only for SAS
tables.
|
Perform utility
functions
|
Perform the following
steps:
-
Click Print to print the View Data window.
-
Click Refresh to refresh the data in the View Data window.
|
|
Perform the following steps:
-
Highlight one or more rows of data.
Then, click Copy to copy the selected text
into the copy buffer.
-
Place the cursor in the row where
you want to place the data. Then, click Paste to paste the data into the table. Note that you can also use Paste Special to paste more at once.
|
Undo or redo
editing operations
|
Perform the following
steps:
-
Click Undo last action to reverse the most recent editing operation.
-
Click Redo last action to restore the results of the most recent editing operation.
|
Search the data displayed in View
Data window
|
Perform the following steps:
-
Click Show search pane. Then, use the search toolbar to search for string occurrences in
the data set that is currently displayed in the View Data window.
|
Determine what is displayed in
the column headings
|
You can display any combination
of column metadata, physical column names, and descriptions in the
column headings.
-
Click Show column name
in column header to display physical column names in
the column headings.
-
Click Show column description
in column header to display displays optional descriptions
in the column headings.
|
Commit or delete editing changes
|
Perform the following steps:
-
Click Save edited row to commit the changes that you have made to the currently edited
row.
-
Click Delete selected
rows to delete the changes that you have made to the
currently edited row.
|
To hide,
show, hold, and release columns, right-click on a column name and
select an appropriate option from the pop-up menu.
To set
options for the
View Data window, select
ToolOptions from the SAS Data Integration Studio menu bar to
display the
Options window. Then, click the
View Data tab.