Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell’s measure. The maximum number of records, by default, is set to 300,000. Feasibly t…
Tag: Uncategorized
Make a name for yourself at SAS Global Forum
Celebrity fame (I’m told) is overrated. Do you really want hordes of people to recognize you in the shopping mall or while you wait at a red light? Of course you don’t. And that’s why I advise you to never win the American Idol competition (nor should you lose with […]
SAS Analytics 2011 Conference Series
The SAS Analytics 2011 Conference Series concluded with more than 1,000 people in attendance from 409 companies and 29 countries. With numerous learning and networking opportunities, those who attended the event in Orlando, Florida last month walked aw…
Retail therapy-the SAS way
It’s mid-afternoon. Day 2 of the PRG2 class. Students return satiated from lunch. Some slipped into this course without taking PRG1 so they missed out on some basics. I’m trying to explain how SAS thinks. I use slides, draw pix, do everything exc…
Using Windows PowerShell to report on your SAS Enterprise Guide project files
This blog post is a “mashup” of a couple of my previous posts, combining the lessons to create something brand new that I hope you will find useful. First, let’s review what we know: SAS Enterprise Guide supports a scriptable object model, which allows you to write scripts or programs […]
Adding format catalogs without loosing others
As I mentioned when creating a user-defined format for Information Maps in a prior post custom or user-defined formats can be created and stored quickly in the default format catalog for all Business Intelligence products within “Lev1\SASApp\SASEnviron…
Revisiting the starting file location for Enterprise Guide
Years ago and a seemingly far galaxy away, I wrote about how to modify 9.1.3 to start Enterprise Guide users in a different location for the File folder. By default, the user only can access their personal SAS Temporary File. Why change this? I would p…
Day Two Recap from Analytics 2011
Well Analytics 2011 is officially a wrap. (OK, that’s not completely true, we still have 3 days of post-conference training left to deliver to around 300 attendees.) Now that we’ve reached the end of the event, I can say the conference was a tremen…