Sorry about not getting a post out last week, but I spent a good part of it cowering under my desk in fear. The SAS Security office issued a warning that there were wild coyotes roaming the campus, and I was having post-traumatic flashbacks to a painful encounter I once
I’m excited to announce that SAS Press will have two more new books available for sale soon! Output Delivery System: The Basics and Beyond by Lauren Haworth, Cynthia Zender, and Michele Burlew, and Combining and Modifying SAS Data Sets: Examples, Second Edition by Michele Burlew will be available November 16th.
It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query
If you want to save money when you register for SAS Global Forum 2010, check out the two new package offers. Both offers bundle popular registration options at a discount. Not only will they save you money, these special packages may also help you with getting conference approval. It’s an
The SAS Business Intelligence suite includes the ability to map data via the ESRI Map Service within various web clients (and even Enterprise Guide). Steps: Create an ESRI Map via ArcMap Publish to ArcGIS Server via ArcCatalog Define a New Map Service in SAS Management Console Set a cube dimension as
If you've read this blog before, then you already know about the ODS statistical graphics that are available in SAS 9.2. We've been talking about this innovation at SAS for years. Now it's time to spread the news. Do your colleagues a favor: forward this post to them, or at
I've just returned from the Los Angeles Basin SAS Users Group (LABSUG), where I both presented a talk and learned from others. (The meeting was in Pasadena, but I did get a chance to tour the area, as you can see from my picture.) The title of my talk was
The North Carolina State Fair just closed. This year’s theme was a “A Whole Lotta Happy” and drew in a record-breaking 900,000 people. Whether you go there for the rides or the games or the exhibits or the animals or the giant pumpkins or the latest fried concoction, the State
Have you seen the new SAS Add-in to MS Office? There are new features worth pointing out & hopefully this will help convince you that now is the time to switch! In SAS Management Console, three built in security roles have been estabilished to accurately assign functionality per user or group.
Yesterday at The Premier Business Leadership Series, I had the tremendous pleasure of attending the panel debate Balancing Intuition and Analytics in Decision Making. The panelists were: Malcolm Gladwell - Best-selling author of Outliers: The Story of Success, Blink and The Tipping Point; Tom Davenport - Best-selling author of Competing
Decision management expert James Taylor wins the prize for most prolific blogger from The Series. James gives us thorough summaries of great presentations on: Balancing Intuition and Analytics in Decision Making. Analytics & Innovation, Analytics in the Executive Suite. SAS Media Day customer panels on fraud detection. and optimization. By
Malcolm Gladwell, author of Outliers and Blink, and Tom Davenport, Babson College professor and author of Competing on Analytics, engaged this morning in a debate on a live Webcast onsite at The Premier Business Leadership Series at Caesars Palace, Las Vegas. The theme of the debate is analytics vs. instinct:
Tuesday was a great day at M2009. I was able to talk to SAS Press author Randy Collica, who is working on a new edition of CRM Segmentation and Clustering Using SAS Enterprise Miner. I interviewed him and Curt Hinrichs, another SAS Press author, who is a coauthor of the
Last week I was a guest of Gaurav Verma on the SAS Applying Business Analytics Web Series, and presented “What Management Must Know About Forecasting.” One of the most important things you can bring to management’s attention is the benefit of making your demand forecastable. In forecasting we tend to
With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below: SAS provides a knowledge base entry at: http://support.sas.com/kb/32/009.html to show how this can be done with a
Yesterday I attended a virtual talk by Bob Rodriguez on his famous topic: ODS Statistical Graphics in SAS 9.2. You can learn lots of details by reading his paper. Bob's paper shows examples of the graphs you can get, how to control their appearance, and what SAS syntax to use.
The route that I use from my home in Raleigh to the SAS Cary headquarters takes me by two exits for the now-running NC State Fair. Last year’s total attendance was 765,067, and hopes are high that this year’s 142nd fair will be another success. So what does the State
Bulk editing of multiple data elements An example of this is when you have 10 items that are numerical and therefore are set to allow measures, but should be classified as categorical (such as serial numbers and ids), you can select all of these values, now you can in one
I arrived at work this AM to see a link to this blog featured as part of the sasCommunity.org Tip of the Day. If you clicked on that link and landed here, welcome! I hope it was worth the click. Please, make yourself at home and browse through the 2
A customer posted on the discussion forum that, much his dismay, SAS Enterprise Guide sets the NOFMTERR option automatically when connecting to a SAS session. The FMTERR|NOFMTERR option specifies whether SAS should report an error when you attempt to reference a data column that has a SAS format applied, but
I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't
Included are a few of my favorite things about the new OLAP Server (for SAS 9.2 EBI Installations). Export/Import via SAS spk file The .spk files are packages that contain everything needed to export from Development and import into Production. This is an IDEAL way to reduce dev-test-prod interactions on the
I found this excellent example of What Not To Do on graphjam.com. I was inspired to see if I could recreate something similar in SAS. You see the result here. Yes, the PIE3D statement is ready to do your bidding. If that's what you really want.
There are some things about forecasting that you may only discover by being a forecaster. Simply managing a forecasting process, or being a downstream consumer of the forecast, isn't always enough. If you have something to say to your management about forecasting, but would rather avoid the confrontation, maybe we
Along with hundreds of SAS users, Alison (of sas.com fame) is attending the MidWest SAS User Group meeting. She recently "live-blogged" the keynote presentation from Suzanne Gordon, our CIO. Suzanne does us proud every time. Check out what she had to say to the MWSUG attendees about her start at
After mentioning the requirements in SAS Management Console to create and edit Shared Prompts (https://blogs.sas.com/content/bi/2009/09/24/creating-a-shared-prompt-for-multiple-imaps-and-stps-9-2/), I then came across functionality in SAS Enterprise Guide 4.2. In the 'Server List', there is a small blue circle with a 1-2-3 and when you mouse over you will see 'Prompt Manager'. When adding
Graduate and undergraduate students are eligible to apply for the SAS Student Ambassador Program, which covers the cost of travel expenses and registration fees paid to attend SAS Global Forum 2010. What’s the “catch?” You must complete an application and submit a presentation abstract and working draft by midnight October
A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either
Included are several of the key elements of the new Configuration Manager Plugin that I heart. 1. Modifying the Web Connection Information One of the MAIN items I love about the new version is the ability to modify the configuration of the Web Applications WITHOUT redeploying all the war files. You
Hmmm. Let’s see. Facebook. Check. Twitter. Check. LinkedIn. Check. That’s about it for me, social media Website-wise. Guess I got that covered. What? You say there’s more? Lots more? Boy, is there ever. Wikipedia lists 157 active social networking sites. My favorite in that bunch, which I’ve not been quite
