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.
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 …
When a data item is created in SAS Information Map Studio, the defaults are assigned for classifications and aggregations. If the data item is a percentage, this defaults may not make sense. For instance, the following figure shows the Gross Margin in scientific notation instead of a percentage.
When the data item was imported, the default aggregation method was SUM, which does not work in this …
SAS Enterprise Business Intelligence (BI) is a suite of applications that allows you to prepare and display data. Here is a quick overview to help you learn the SAS BI product names and purposes.
Your data may be in a relational database (Oracle, Teradata, MySQL, etc). The data is then placed in OLAP cubes, information maps, or in some cases a SAS dataset so it …
As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore. Here is a list of free sources that I have found that can help as you learn and want to challenge yourself.
Simple Data Tables
Here are some sources for simple data tables. These are datasets with all of the data contained …
Building Business Intelligence Using SAS Book
SAS Business Intelligence (BI) package provides an interface for multiple audiences to dissect, discover, and decide on what the data means to their organization. This book shows you the SAS business intelligence capabilities, features, and contains the most sought after tips and tricks to bring a novice user up to speed quickly!
SAS BI Book Overview
Each chapter highlights a specific SAS business …