Working in a Multidimensional Crosstabulation Table

Suppose that you have a report that contains a table with many rows. The table contains columns for product groups and products. You cannot see a specific product in the table's viewable rows. You can use the Find option to bring the row that contains the first occurrence of the product into view. You can also find the next occurrence of the string, or you can close the Find dialog box.
To use the Find option, complete these steps:
  1. Right-click a multidimensional crosstabulation table, and then click Find.
  2. In the Find dialog box, select Cell values by row.
  3. Make sure that Equal to is selected for Condition.
  4. Type the value that you want to find (for example, 100).
    Find Dialog Box
    Find Dialog Box
  5. Click Find Next. The table repositions when it finds the value.
  6. (Optional) To find other occurrences of the same value, click Find Next again. If no other matching values are found, a message displays.
Copyright © SAS Institute Inc. All Rights Reserved.