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 Tags

Articles tagged with: SAS Add-In for MS Office

SAS Office Analytics: Working with Your Inner SAS Programmer

2014-03-12 – 8:00 AM
2014-03-two sides of face

When working with new or even casual SAS BI users, the SAS Office Analytics really bridges the gap between “I’m not a SAS programmer” and “I have 1000’s of ideas for data visualizations”. Users need an easy way to access the data warehouse and create reports or answer simple questions. The SAS Office Analytics package (aka SAS Add-In for Microsoft Office) a natural choice since …

SAS Add-In for MS Office: Abe Lincoln Sends Glee in a Snowstorm

2014-02-18 – 6:54 AM
lincoln loves sas

It’s been really snowy and cold in North Carolina for the past week.  About 5″ of snow fell in 2 hours, which unleashed pandemonium. Power was out for some, flights were cancelled because the airport shutdown, and many people even left their cars beside the road electing to walk home or stay in a hotel for the night. Since I work from home, it was …

SAS Stored Processes: Querying a Stored Process from Excel without the Add-In

2013-02-20 – 7:39 AM
stored process without AMO

What do I have in common with a guy in Norway?  Well, if you look at my last name Aanderud – you might think he is a family member.  Turns out Stig Eide and I both use SAS Stored Processes to solve issues!  Recently this SAS platform administrator asked if he could demonstrate a trick for using a Excel to query data in a stored process …

SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide

2012-05-07 – 7:06 AM
Showing OLAP Member Properties in Excel

As a follow-up to my earlier post on taking advantage of OLAP member properties, you can also display OLAP member properties through the Add-in for Microsoft Office as well as SAS Enterprise Guide.  I’m a huge fan of Enterprise Guide, so it’s nice to have that ability but even nicer when the more common information consumer can display member properties through a Pivot Table in …

SAS Enterprise Guide: Pick a Winner Randomly

2012-04-17 – 7:29 AM
sas stored process book winners

To pick the winners of the 50 Keys to Learning SAS Stored Processes book, my first thought was to print the list and then put everyone’s name in a hat. Angela brilliantly suggested that we use one of the SAS Random functions.  However, since there was a list  of names I really needed a random number between two values.  This brought to mind the MS …