When you connect to a SAS environment with SAS Enterprise Guide, are you a single, consistent person? Or do you have more identities than Chevy Chase in Fletch? When you connect to a SAS environment, you can be many people at once: You are logged into your Windows account on
The SAS Talks series is a big hit, and now we've got a landing page where you can find previously recorded talks, plus information about upcoming talks. You can learn about SAS programming with SAS Enterprise Guide, ODS statistical graphics, fancy multi-sheet output for Microsoft Excel from SAS, and more!
Like many of you, I’m closely following the last season of the ABC drama Lost. I’ve followed Jack, Kate, Hurley, Sawyer et al. through six long years of island confusion. Now, with nine episodes left until the series ends for good, I can see how the writers are setting us
Business problem: By default, OLAP cubes calculate aggregations at each possible intersection of levels in one or more dimensions. However, there are situations where aggregations cannot be completed on the fly for all intersections within the cube due to business rules for some data levels. Also, the source data table
I LOVE to read. Six months ago, it was “bah humbug” for me when it came to eBooks. I want my print books! Then I got the Apple iPhone for Christmas and whoa, now I love reading online. Have you tried it yet? SAS Publishing Operations is working with the
If you would like for the BI Dashboard to send you an alert via email, you must ensure that the email address is included for each user that will be receiving emails. This is located in SAS Management Console User Manager. Instructions: http://support.sas.com/documentation/cdl/en/biwaag/63059/HTML/default/a003311779.htm Example:
In one of my previous posts, I challenged myself to use SAS to create a monthly household budget and I’m happy to report that I have started this process. I have a few months worth of data and have begun to merge this information into data sets. With the combination
Contributed by Dave Russo, Technical Writer, SAS Publications Most of us in the Publications division spend our days capturing, refining, delivering, or promoting knowledge about SAS software. Like many of our customers, we’re in the knowledge business. As part of that business, I have the privilege of leading a small
You may choose to address security of who can view what dashboards within a SAS Information Delivery Portal page by managing the 'Sharing' capabilities at the Page or Portlet levels, however the most gradular level might also require a 'lock down' to avoid users surfing for and locating dashboards they
Check out AnnMaria's blog covering what she's learned by being on the bleeding edge: using SAS 9.2 for Windows x64 on a Win7 virtual machine. Also, her short primer on XPT files makes me want to add some native capability into SAS Enterprise Guide. If your goal is to send
Would you like to get a quick preview of the gauge you are using in the BI Dashboard Indicator? Just tap the 'Select ...' button to the right of the 'Gauge type:' dropdown box. There are then images of what these gauges look like, such as the 'Dials' category below:
Information Map Studio allows data managers the ability to join tables, create new data elements, and label/format data items for business consumption. However due to this flexibility users must weigh the benefits of customizing information maps against the performance impacts of completing many of these tasks within the Information Map
Ran across a situation last week that proved extremely helpful. We needed to generate detailed logs on Web Report Studio use in order to verify pooling was setup correctly and then to monitor performance of some poor performers. The easiest and most straightforward way to accomplish this was to follow
I am blogging from O'Reilly's Tools of Change Conference in New York City, where I will be co-presenting a case study today with my colleague Sean Gargan about the work we have done over the past year with social media. While working on our presentation, Sean and I realized that
Which versions of MySQL are supported by SAS 9.1.3 for Windows? Is the 64-bit version of Oracle 11g supported on the 64-bit version of SAS 9.2 on Linux? You can find the answers to these questions and others like it by consulting the SAS/ACCESS Validation Matrix: pick your SAS version,
SAS Global Forum will be here before you know it, and we’ll have the opportunity to meet with the world’s largest assembly of SAS users. If you’ve attended before, you know about what to expect. There are lots of learning opportunities available on Sunday morning and afternoon, so if you
Within SAS, we have a strong blogging community made up of SAS employees. Those of us who read or contribute to the blog content on the internal SAS web got a special "shout out" from Fortune magazine, within its coverage of SAS as the top workplace in the USA. The
I've been to a bunch of SAS Global Forum (née SUGI) events over the years. I always look forward to going, because I always think that by being there in person, I'll be able to provide some customers with exactly the information they need to use SAS better. And I
As you use the Query Builder task in SAS Enterprise Guide, you might notice that it refers to tables and computed columns using names that are different than you expect. For example, instead of a table named CANDY_SALES_HISTORY, the Query Builder might show t1. This is called an alias, and
My last blog post about the Analytics Camp 2010 conference relates to Farhad Islam's talk about "Real-Time Analytics, Getting results when you need it". Farhad proposed that changes must occur not only at the Business Intelligence vendor level, but also to both operating systems and hardware to increase response time of analytical requests.
During the Analytics Camp 2010 event last weekend, I attended Manya Mayes presentation on Text Analytics. I noted two 'All Abouts' that affect any content analysis being completed. No, not the Girl Scout Cookies, but what really ensures successful analysis of content. And by content, I mean any non-numeric, non-standard context, which
During Analytics Camp 2010 this past weekend, I facilitated a discussion with a great group of attendees looking to create or improve their own dashboards. The question asked was: "What should all dashboards have to make them useful & successful?" During this discussion I added *** within my notes around
I’ve spent quite a while now going through chapter 8, “Creating Enhanced List and Summary Reports,” in the Base Certification Prep Guide. This topic should be straightforward, I keep telling myself. So why did I score 40% on the quiz? Thinking that I probably needed to delve a little deeper,
Andy wrote in the NOTE: blog that he's stumbled upon a few custom tasks to extend features in SAS Enterprise Guide. He wondered aloud whether there might be more "free" tasks out there, available for use by anyone who can find them and download them. The answer is: You betcha!*
In case you missed the business news last week, SAS (the company that pays me to write this blog, and the leader in business analytics) was named #1 on the FORTUNE 100 Best Companies to Work For 2010 list. Having been a user (and huge fan) of SAS software since
Out of the box, no members of the SASUSERS group are allowed to create OLAP Cubes. In 9.2, the error message states "The security package failed while authenticating a user", included below is a screen shot. The fastest way to remediate this is to allow the SASUSERS group to have
The 4.2 version of SAS Information Map Studio provides data managers with the ability to create a dynamic filter based on dates. This is extremely valuable for things such as daily reports. Included below is an example of a new filter that is built off a date formatted data item.
Subtitle: An accounting of accounts which, by all accounts, you should hold accountable. With the introduction of the SAS metadata server for use with SAS Business Intelligence, the role of the SAS administrator became more important. In SAS 9.1.3 a number of new standard "accounts" -- user IDs that serve
Divide each difficulty into as many parts as is feasible and necessary to resolve it. -Rene Descartes A great quote to apply to many things in life, including this path towards certification. Realizing that I needed a review, I enrolled in a three day, onsite Programming I class here in
Conditional formatting for numeric values is pretty simple for users in Web Report Studio, but how about colors on categorical values - such as customer name, product type, issue severity etc. (This was requested from a WRS user in the SAS Discussion Forums) Turns out this can be done, however
