Subscribe to DSC Newsletter

Tricia Aanderud's Blog (35)

HTML for SAS Programmers

The SAS BI web clients each have their own link (or URL).  When working across many customer sites or even just using my own demo sites –  there can be a lot of links to track (BI Dashboard, Portal, WRS, etc). Certainly I can add bookmarks to my browser –  but when moving to different systems I found it’s easier to just have a little .HTML file that I can edit as needed.

Set Your BI Toolset Quick Ref Bookmark

If you are not sure what I’m trying to describe –  the following…


Added by Tricia Aanderud on June 25, 2012 at 5:07am — No Comments

Business Intelligence: Good Things to Share!

I have been very busy in the past month writing guest post for some of the different blogs that I follow and find interesting.  I’ve also been reading some books that I wanted to share with you!

Blogging! Blogging! and More Blogging!


Added by Tricia Aanderud on June 22, 2012 at 6:03am — No Comments

SAS Enterprise Guide: Writing Code to Capture New Twitter Followers

While at the SAS Global Forum, someone said to me – “You cannot write code in SAS Enterprise Guide.”  It was a little shocking to me that the person thought SAS Enterprise Guide was all wizards, flow diagrams, and magic. After talking to a few other folks I have found that it is a common myth.  

News Flash!  You can just code in SAS Enterprise Guide!  Today I’ll show you how I pull data from Outlook into SAS Enterprise Guide to create a tweet.  And I’m just going to…


Added by Tricia Aanderud on June 20, 2012 at 4:54am — No Comments

SAS OLAP Cubes: Automatically Collect ARM Performance Logs

Steve Overton shares this information with us:

Collecting ARM logs can be extremely useful when tuning OLAP cubes for faster response.  The ARM log (which stands for Application Response Measurement) collects vital usage information for OLAP cubes using the SAS OLAP Server logging facility.  SAS OLAP Cube studio can analyze these logs to assist with aggregation building to make OLAP cubes return faster results.  Angela Hall discusses…


Added by Tricia Aanderud on June 18, 2012 at 7:25am — No Comments

SAS EG 5.1 – Data Exploration Feature

I really dig the SAS Enterprise Guide 5.1 - Data Explorer Tool.  How many times have you received a new data set that you know nothing about? While it's not like it takes forever to run some PROC FREQ/MEANS - but what if it's already done for you or can be done quickly?  Did that get your attention?

Here's how to use this new feature with your data.

Open Data Exploration from File Menu

From the File menu, select Open > Data Exploration.  Then navigate to…


Added by Tricia Aanderud on June 13, 2012 at 6:35am — No Comments

SAS Enterprise Guide: Best Practice for Centralized User Storage

Steve Overton shares this tip for SAS Enterprise Guide users and administrators!

fileslink SAS Enterprise Guide: Best Practice for Centralized User Storage


A nice feature of SAS Enterprise Guide is the “Files” folder.  This provides direct access to the file system where the workspace server is running.  You can take advantage of this by configuring a central location where users can store data, SAS…


Added by Tricia Aanderud on June 11, 2012 at 4:44am — No Comments

User Conferences = Busy Summer for Me!

 It's going to be a busy summer with a lot of travel.  I've been invited to several user conferences so I'm really excited to get to meet even more SAS users, pick up some great tips for others, and wear myself out chatting. 

Wisconsin Illinois SAS Users Summer Conference

Milwaukee, WI

June 27

This SAS user group is having a…


Added by Tricia Aanderud on June 4, 2012 at 3:30am — No Comments

SAS Enterprise Guide: Import Odd Spreadsheet Data

Perhaps you took my advise a few weeks back and took advantage of the amazing (trumps blare!) SAS Enterprise Guide ability to import MS Excel spreadsheets.  However, if your spreadsheet is a little different – then you may run into some issue when you go to import it.  For instance, look at this…


Added by Tricia Aanderud on May 30, 2012 at 3:27pm — No Comments

Web Report Studio: Adding Drill-Down Filter Based on a Date

When I was creating the Summary and Detailed reports for the SAS Global Forum paper, I was demonstrating how to link from the weekly chart to the detailed report about the week.  On my first try with my Week Filter based on the date value – it just would not work.  Eeek!  To fix the problem I made a new data item that was a character value.  This posts talks about my strategy.  [You can read our paper "…


Added by Tricia Aanderud on May 22, 2012 at 4:20am — No Comments

SAS BI: Does Your Organization Have a BI Strategy?


One of the best things about attending the SAS Global Forum is all the brilliant people you get to meet.  Guy Garrett’s presentation about planning a BI strategy was quiet popular and I have to say he was very witty.  Turns out implementing a BI strategy is similar to dating –
who knew?  Anyway – here’s a follow up from Guy – I encourage you to sign-up for the
Achieve Intelligence monthly newsletter for more goodies.

What is…


Added by Tricia Aanderud on May 18, 2012 at 5:00am — No Comments

SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch

Google Analytics uses data from your Website to prepare a neat looking application where you can explore your data and answer what I consider your first-level questions. First-level questions are the most basic things you might want to know, such as How many? What Time Period? It is the second- and third-level questions where the analysis and action plans come into play. After all, it’s not enough to know how many people visited the site – you need to know what segment attracted them and how…


Added by Tricia Aanderud on May 17, 2012 at 4:39am — No Comments

SAS Stored Processes: 3 Tips to Improve Your Prompts

Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break.  Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap!…


Added by Tricia Aanderud on May 16, 2012 at 6:01am — No Comments

SAS Global Forum: Here’s the Wrap Up!

SAS Global Forum 2012 was a success! After a whirlwind week of activities followed by a vacation and week of rest – I’m ready to give you some highlights.  It was a lot of fun! Tip: Click on any picture to enlarge it.

Day 1 – Saturday Ready for the Tweet-Up

The biggest drama was at the airport – our flight was delayed due to mechanical failure so I decided it might be better to take a later flight. Met…


Added by Tricia Aanderud on May 14, 2012 at 6:46am — No Comments

SAS Enterprise Guide: Import the Excel Spreadsheet – Easy Peasy

One SAS Enterprise Guide feature I particularly like is the ability to import Microsoft Excel data quickly and easily.  SAS offers many ways to work with Excel spreadsheets but often I find I just want to extract data from Excel and get on with my job.  

Use a “Known Good” First Time

If you are trying this process for the first time, use a “known good” or simple spreadsheet so if any issues arise you can at least eliminate the data as the cause. When this process fails, I…


Added by Tricia Aanderud on May 10, 2012 at 10:00am — No Comments

Stored Processes: 3 Ways to Edit a Stored Process

Some may not realize that you can edit a SAS Stored Process in multiple ways (depending on your permissions).  Today I show you three different ways to reach the stored process code.  By the way, I’m using SAS Enterprise Guide 4.3 and SAS Management Console 9.3 – so your windows may look different.

Method 1: SAS Enterprise Guide

Many of you are aware of this method already.  Just for review – here’s how you open a stored process and then change it with SAS Enterprise Guide.…


Added by Tricia Aanderud on May 8, 2012 at 11:25am — No Comments

On Data Science Central

© 2020 is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service