Working with Tables :: SAS(R) Visual Analytics 6.1: User's Guide

About Tables

A table shows data values as text. The values for each measure or category that is assigned to the table are displayed as columns. The data values in the table are not aggregated.

Note: For very large data sources, the table visualization displays only the first two billion (2,147,483,647) rows.

Note: If you sort the table, then the table displays only the first 5,000 sorted rows.

Specify Properties for a Table

On the Properties tab, you can specify the following option:

Name

specifies the name of the visualization.

Data Roles for a Table

The basic data role for a table is a column. A column can be a data item of any type. You can add any number of columns to a table.

Managing Columns

Sort Columns

To sort the table by a column, click the column heading. An arrow appears in the column heading to indicate the sorting. If the arrow points upward, the sort is ascending. If the arrow points downward, then the sort is descending.

Note: If you sort the table, then the table displays only the first 5,000 sorted rows.

Rearrange Columns

To rearrange your columns, drag and drop the column headings.

Resize Columns

To resize your columns, click and drag the left or right edge of the column headings.