Posts Tagged ‘ Add-In for MS Office ’

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

February 18, 2014
By
SAS Add-In for MS Office: Abe Lincoln Sends Glee in a Snowstorm

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...
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off

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

February 20, 2013
By
SAS Stored Processes: Querying a Stored Process from Excel without the Add-In

Stig Eide

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...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

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

May 7, 2012
By
SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide

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...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

SAS Enterprise Guide: Pick a Winner Randomly

April 17, 2012
By
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...
Read more »

Tags: , ,
Posted in SAS | Comments Off

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

February 29, 2012
By
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...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

What Can I Do With a Stored Process?

February 26, 2012
By
What Can I Do With a Stored Process?

Often I refer to SAS Stored Processes as the workhorse of the SAS BI tools … you can use these little devils everywhere sometimes as Band-Aid, sometimes as the star, and sometimes as a background player. In a past post, I showed you how to use a stored process to add dashboard dials to...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

SAS Add-In to MS Office: Refreshing the Data & Breaking the Link

February 9, 2012
By
SAS Add-In to MS Office: Refreshing the Data & Breaking the Link

If you use SAS Add-In to Microsoft Office – specifically Excel, then you already know how awesome it is to link to the SAS data on the server. First, if you are using data that needs to be refreshed – just a click of the button brings you the new rows and your report...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Peek Inside SAS BI Book: Building Business Intelligence with SAS

February 4, 2012
By
Peek Inside SAS BI Book: Building Business Intelligence with SAS

You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write...
Read more »

Tags: , , , , , , , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.