EXPLORE

Lets you experiment with your data.
Restriction: You cannot open the EXPLORE window unless your report contains at least one group or order variable.

Details

Path

Editthen selectExplore Data

Description

In the EXPLORE window, you can
  • subset the data with list boxes
  • suppress the display of a column with the Remove Column check box
  • change the order of the columns with Rotate columns
Note: The results of your manipulations in the EXPLORE window appear in the REPORT window but are not saved in report definitions.

Window Features

list boxes
The EXPLORE window contains three list boxes. These boxes contain the value All levels as well as actual values for the first three group or order variables in your report. The values reflect any WHERE clause processing that is in effect. For example, if you use a WHERE clause to subset the data so that it includes only the northeast and northwest sectors, then the only values that appear in the list box for Sector are All levels, Northeast, and Northwest. Selecting All levels in this case displays rows of the report for only the northeast and northwest sectors. To see data for all the sectors, you must clear the WHERE clause before you open the EXPLORE window.
Selecting values in the list boxes restricts the display in the REPORT window to the values that you select. If you select incompatible values, then PROC REPORT returns an error.
Remove Column
Above each list box in the EXPLORE window is a check box labeled Remove Column. Selecting this check box and applying the change removes the column from the REPORT window. You can easily restore the column by clearing the check box and applying that change.

Buttons

OK
applies the information in the EXPLORE window to the report and closes the window.
Apply
applies the information in the EXPLORE window to the report and keeps the window open.
Rotate columns
changes the order of the variables displayed in the list boxes. Each variable that can move one column to the left does; the leftmost variable moves to the third column.
Cancel
closes the EXPLORE window without applying changes made with APPLY.