The REPORT Procedure

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.

Path

Edit Explore Data

Description

In the EXPLORE window you can

subset the data with list boxes
suppress the display of a column with the Remove Column checkbox
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. [cautionend]

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, 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, 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.

Pushbuttons

[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].

Chapter Contents
Previous
Next
Top of Page