Working with VIEWTABLE :: SAS(R) 9.3 Language Reference: Concepts, Second Edition

Overview of VIEWTABLE

To manipulate data interactively, you can use SAS software's table editor, the VIEWTABLE window. In the VIEWTABLE window, you can create a new table, and browse or edit an existing table.

View the Contents of a SAS Data Set

To view the contents of a data set with VIEWTABLE, follow these steps:

Open SAS Explorer and select a library.

The contents of the library appear.
Double-click a data set within the library.

The VIEWTABLE window appears and is populated with data from the data set:
Scroll the VIEWTABLE window to view all of the data in your data set.

Move Columns in a Table

Within the VIEWTABLE window, you can rearrange columns in your table. To move columns in your table, follow these steps:

Left-click a column heading for the column that you want to move.
Drag and drop the heading onto another column heading.

In this example, if you left-click the heading Product Type, and then drag and drop Product Type onto Country, the Product Type column moves to the right of the Country column.

Temporarily Change Column Headings

Within the VIEWTABLE window, you can temporarily change column headings. To temporarily change column headings, follow these steps:

Right-click the heading for the column that you want to change, and then select Column Attributes from the menu.

In this example, the column heading Country is listed in the Name field of the Column Attributes window.
In the Label field of the Column Attributes window, enter the new name of the column heading (as shown above) and then click Apply.

The column heading in VIEWTABLE changes to the new name. In this example, the label was changed to Country of Origin.
Click Close to close the Column Attributes window.

Sort by Values of a Column

You can sort your table in ascending or descending order, based on the values in a column. You can sort data permanently or create a sorted copy of your table.

To sort your table, follow these steps:

Right-click the heading of the column on which you want to sort, and select Sort from the menu.
Select Ascending or Descending from the menu.
When the following warning message appears, click Yes to create a sorted copy of the table.

Note: If you selected Edit Mode after opening the table and clicking a data cell, this window does not appear. SAS updates the original table.
In the Sort window, enter the name of the new sorted table.

In this example, the name of the sorted table is FurnSalesSorted.
Click OK.

The rows in the new table are sorted in descending order by values of Actual Sales.

Edit Cell Values

By default, VIEWTABLE opens existing tables in browse mode, which protects the table data. To edit the table, you need to switch to Edit mode. To switch to Edit mode, follow these steps:

With the table open, select EditEdit Mode from the Edit menu.
Left-click a cell in the table, and the value in the cell is highlighted.

In this example, the third cell in the fourth row is selected.
Enter a new value in the cell and press Enter.

In this example, the cell has been updated with the value North Carolina.
Select FileClose from the File menu.
When prompted to save pending changes to the table, click Yes to save your changes or No to disregard changes.

Note: If you make changes in one row and then edit cells in another row, the changes in the first row are automatically saved. When you select File

Close, you are prompted to save the pending changes to the second row.