BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

SAS Info Map: I want an Average not a Sum!

Submitted by on 2011-09-14 – 3:00 AM

In SAS Information Map Studio, you can easily set the default measure for a data item in the Properties area.  This advise will not apply to information maps based on a SAS OLAP Cube.

 Change your Data Item Aggregation Defaults

(1)  Use the Default aggregate function drop-down to select the default.  When you set this item to AVERAGE, the data item defaults to Average in SAS Web Report Studio.

(2) You can control which aggregates are available to the data item.  For instance, for a percentage (such as discount) you probably never want that to be SUM – so de-select it to prevent the action.

sas information map studio aggregations

Based on the data item there will be different aggregation functions available.  So a data item that is a percentage will not offer the same aggregations as a single number.  Consider the following examples.

In this example – it’s a “normal” data item meaning it’s numeric.  You can see that all the aggregate functions are available for it.

sas information map studio aggregations for data item


For this example, the data item is a calculated percentage.  You can only choose if you want it the result to aggregate as additive or non-additive.  (That’s another blog topic!)

sas information map studio aggregations for non percent data item


Making Changes in Web Report Studio

You can also change the default aggregations for a report in SAS Web Report Studio.  From the Edit pane, select Data > Summarization Options.  In the Summarization Options window you can change how the data item works in the report.  For instance, you may want to display Bounces as an Average instead of a sum.   Notice that changes to the calculated data items (New Visitors (%)) is not allowed.

sas web report studio data item aggregations

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: ,