SAS^® Information Map Studio enables you to change the classification of a numeric variable to a category data item. These data items can also have applied user-defined formats. This usage note explains how these two settings impact the results when they are exported from SAS^® Web Report Studio 4.2 running with the third maintenance release for SAS 9.2 (TS2M3) or later.

This usage note focuses on numeric variables that are not dates. For an explanation of the exporting behavior when the numeric data item is a date, see SAS Note 39964.

This example focuses on a numeric variable named Organization. The following display shows the Organization variable defined as a numeric in the table metadata.

This view shows that the data item is being created as numeric when selected for the information map.

The display below shows Organization defined as a Category data item in an information map. A user-defined format is also applied.

When this data item is used in a SAS Web Report Studio report, the user-defined format is applied to the results.

When you export this report to Excel, you will be able to sort and filter values based on the character values specified by the user-defined format, rather than based on the original numeric values.

If you are running a release prior to the third maintenance release for SAS 9.2 (TS2M3), the user-defined format is not used in Excel, and sorting and filtering is done on the original numeric values.

Operating System and Release Information