A Data Science Central Community
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.
If you are not sure what I’m trying to describe – the following…Continue
Added by Tricia Aanderud on June 25, 2012 at 5:07am — No Comments
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!
Added by Tricia Aanderud on June 22, 2012 at 6:03am — No Comments
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…Continue
Added by Tricia Aanderud on June 20, 2012 at 4:54am — No Comments
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…Continue
Added by Tricia Aanderud on June 18, 2012 at 7:25am — No Comments
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.
From the File menu, select Open > Data Exploration. Then navigate to…Continue
Added by Tricia Aanderud on June 13, 2012 at 6:35am — No Comments
Steve Overton shares this tip for SAS Enterprise Guide users and administrators!
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…Continue
Added by Tricia Aanderud on June 11, 2012 at 4:44am — No Comments
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.
This SAS user group is having a…Continue
Added by Tricia Aanderud on June 4, 2012 at 3:30am — No Comments
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