Add-In for MS Office

Add-In for MS Office
BI Tools
Data Visualization

SAS Office Analytics: Working with Your Inner SAS Programmer

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 […]

Read More
lincoln loves sas
Add-In for MS Office
BI Tools
Data Visualization

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

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 […]

Read More
Add-In for MS Office
BI Tools
Coding & Data
Stored Processes

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

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 […]

Read More
sas stored process book winners
Add-In for MS Office
Coding & Data
Enterprise Guide

SAS Enterprise Guide: Pick a Winner Randomly

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 […]

Read More
add-in excel olap cube viewer more space
Add-In for MS Office
BI Tools

Excel and OLAP Viewer: Not enough room for the Cube!

When you use the OLAP Viewer in Microsoft Excel you may have run into the window borders – literally.  Your cube and analysis needs more space!   Scroll, Scroll, and Scroll to See the Cube Data  When you open the OLAP cube in the MS Excel OLAP Viewer the default cube size dictates the area […]

Read More