Subscribe to DSC Newsletter

Tricia Aanderud's Blog – May 2012 Archive (8)

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…

Continue

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 "…

Continue

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…

Continue

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…

Continue

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!…

Continue

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…

Continue

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…

Continue

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.…

Continue

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

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

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