A Data Science Central Community
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
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
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.
Added by Tricia Aanderud on May 18, 2012 at 5:00am — No Comments
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
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 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
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.
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
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.
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