Previous Page | Next Page

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 [arrow] Explore Data


Description

In the EXPLORE window you can

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

Previous Page | Next Page | Top of Page