The Columns Viewer helps you quickly select columns by attributes, properties, and statistics, particularly in a data table that has many columns. You can view summary statistics and properties for those columns, view quartiles in the summary statistics, subset the data, and more. And columns in the Columns Viewer window are also linked to the data table columns (Figure 4.10).
Figure 4.10 Linked Columns in the Column Viewer
The Columns Viewer gives you a quick view of data table characteristics. For example, the Summary Statistics report shows which columns contain missing values (Figure 4.11). You can select those columns in the report and then exclude them in the data table.
Figure 4.11 Identify Missing Values
|
•
|
the number of rows with missing values (N Missing)
|
|
•
|
the number of categories (N Categories)
|
|
•
|
Creates a linked Summary Statistics report for the selected columns. Right-click to select options such as sorting by column or creating a data table. Select Show Quartiles to include lower quartiles, upper quartiles, and interquartile ranges. And to create a linked data table from all columns in the report, select Data Table View from the Summary Statistics red triangle menu.
Shows a list of column properties in the Columns with Properties report. Select the properties that you want to find and then click OK to create a linked report from all columns. Or you can select columns first in the Select Columns list and then show the list of properties just for those columns.
Tip: Each time you click the Show Summary or Find Columns with Properties buttons, a new report is added to the window. To delete a report, select Remove from the report’s red triangle menu.
|
1.
|
|
2.
|
Select Cols > Columns Viewer to open the Data Table Columns Viewer window.
|
|
3.
|
The Columns with Properties report appears. Several columns include the Formula property (Figure 4.12). Because the list is so long, you want to view all formula columns together.
Figure 4.12 Select the Formula Column Property
|
4.
|
Figure 4.13 Sort by Column
|
5.
|
|
1.
|
|
2.
|
Select Cols > Columns Viewer to open the Data Table Columns Viewer window.
|
|
3.
|
In the Select Columns red triangle menu, select Name Starts With.
|
|
4.
|
Figure 4.14 Filter Columns by Name
|
5.
|
Figure 4.15 Summary Statistics for Selected Columns
|
6.
|
Right-click in the report and select Sort by Column.
|
|
7.
|
Notice that PNP6 has no standard deviation, because the minimum, maximum, and mean values are 0.
Figure 4.16 Sorted Std Dev Column
|
8.
|
In the Summary Statistics report, select the row for PNP6 and then display the data table.
|
|
9.
|
View the data table and press Delete to remove the selected column.
|
|
10.
|
To close the Columns Viewer, click the X button in the upper right corner (Windows) or upper left corner (Macintosh) of the window.
|