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 » Archive by Author

Articles by Tricia Aanderud

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.

Web Report Studio: Chops off the columns and rows …

2011-09-22 – 3:00 AM
WRS_02_ugly reports_part2

Do you get a little frustrated by not having all the screen real estate you want when displaying your report?  There may be times when you have 13 columns you want to display.  The following figure shows an example report where I extended the columns.  Before it showed the navigation bar at the top of the report – but I wanted the viewer to see …

Ugly Web Report Studio Reports?

2011-09-21 – 1:00 AM
WRS_05_ugly reports

If you only use the default settings when building Web Report Studio report, the results may not be very attractive.   For instance in the following report the graphs are different sizes and the spacing between them is awkward.

To change the image size, you have to change the settings in the Image Properties.

Right-click the graph and select Properties from the pop-up menu.

Change …

Web Report Studio: Yellow Icons with !

2011-09-15 – 1:00 AM

When you start a new report in Web Report Studio, you may notice that yellow icons with an exclamation point (!) appear in the work area.  This happens when you have not added any data to the objects.  In the example below, the first capture shows the empty objects.  In the second capture, you can see data is available and assigned to the objects.  The …

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

2011-09-14 – 3:00 AM
sas web report studio data item aggregations

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 …

SAS Stored Processes: Where is my stored process code?

2011-09-13 – 5:00 AM
stp_storage location

As you register your stored process, you may notice that the Stored Process wizard incorporates your code in Step 2.  Ever wondered where the feisty little wizard places this code?
In step 3 of the creation process,  you are actually selecting a location and the file name.

The Source filepath is the physical location for the SAS file.
The Source filename defaults to the stored process name.  However, you can …