SAS Institute. The Power to Know

SAS/GRAPH(R) 9.2: Network Visualization Workshop Help

About Data Tables

When you open a data set or a project, SAS/GRAPH Network Visualization Workshop displays the data in one or two tables. A table operates somewhat like a typical spreadsheet. You can edit data, sort data, and perform other tasks.
All views of the data in SAS/GRAPH Network Visualization Workshop (all tables and graphs) are linked through an underlying data model. Therefore, any changes or selections made in a table are also reflected in any other views of that same data.
Note: Changes made to the table remain in effect only while the current project is open. For example, you might change the value of an observation in a table. Then, when you close and later reopen the data sets or the project, your change is not saved.[note end]
You can display a context menu by right-clicking on a column heading or a row heading. The context menu varies depending on the cursor's position when you right-click.
Here is a sample table that is based on link data:
Example Link Data Table
Sample Link Data Table
Column 1
The first column in the table contains the observation label, which is used to identify observation markers in graphs. You can change the labels for variables and observations. For details, see Changing Header Labels .
Column 2
The second column contains marker icons that indicate whether an observation is included in graphs. If you exclude an observation from graphs, then its marker icon disappears. The shape and color of the marker icons indicate the following:
  • In a node data table, a marker icon indicates the marker color and shape associated with the corresponding observation in graphs. The default color is blue, and the default shape is a square.
  • In a link data table, a marker icon indicates the marker color associated with the corresponding observation in graphs. The default color is plum.
You can configure which variable is used to determine marker shapes and colors by setting data attributes. For details, see Specify Data Attributes .
The numeric value in the column heading indicates how many variables the data set contains. If you select one or more variables, then the value changes to indicate the number of selected variables, and the value is displayed within brackets.
Column 3 and 4
The third and fourth columns function as the FROM and TO nodes for your links. Though the FROM and TO variables are the first variables in this example data set, they can correspond to any two columns of your data set. You specify the names for the FROM and TO variables when you set the data attributes.
Additional column
Though not required, you can have additional variables that might be useful for sorting and exploring data.
Index columns
When you load both link and node data, SAS/GRAPH Network Visualization Workshop adds two variables to the links table: From Index and To Index. These variables are derived from the FROM and TO variables in the data set. The derived variables are zero-based indexes into the node data set. Each variable corresponds to a node observation in the node table (the observation is the index value plus one). The variables enable you to look up a node quickly in the node data table rather than scanning through the node data table row by row.

See Also

Selecting Data in a Table