So, you have created a report with a Filter. That filter is pretty evident somewhere in the report anyway (or you just want the USER to have no knowledge of what is not there) so why not remove the filter list at the top of the report? Pretty easy option,
You can use SAS Enterprise Guide to automate most aspects of queries, analytics, and reporting -- including sending e-mail notifications with the results. In this blog post, I'll show you how you can send these results and use Gmail as your e-mail provider. First, some background: SAS Enterprise Guide provides
I'm a computer geek -- much more comfortable behind a keyboard than in front of a camera. But I was glad to put on a nice shirt and visit the SAS video studio so that I could record this message for SAS customers: how does SAS R&D work to support
Contributed by Lou Metzger, Manager, SAS Publishing Sales The way to a man’s heart is through his stomach. In my case, truer words were never spoken. When I was first married, I won a small sum and spent some of the winnings on an excellent cookbook for our new family.
CASE statements are a powerful mechanism in SQL code to analysis, recode, etc data. In Information Map Studio, you can utilize this CASE statement via the Expression Editor Window. Create a new data item and click edit in the 'Expression Settings' area. From the Categories - CASE operator folder, there
So you've got a nightly process that updates a file somewhere. Unfortunetly, something still has it locked and the update fails, the nightly process crashes & burns, and someone at 8am upon arriving decides to blast you for not having updated data ready for them to analyze. Sound familar? There
Just as we all eagerly awaited announcement of the $1 million prize winner of the Pillsbury Bake-Off(R), every forecasting software vendor has endured the "bake-off" hosted by organizations in the market for new forecasting software. Software selection teams utilize a bake-off to help evaluate competing vendors. Vendors are given a
I must recommend that you check out this example from pg 70 of the SAS Stored Process Developers Guide. http://support.sas.com/documentation/cdl/en/stpug/61271/PDF/default/stpug.pdf This is a pretty sweet example of how to upload a file from your machine (via Internet Explorer) into the SAS System. A custom form can be created in html
Contributed by Angela Hall, Technical Architect Wait, what? Doesn’t everyone have a favorite college textbook? Maybe I’m that much of a SAS geek, my favorite college text is sitting right next to my desk & has ever since I left college. Coffee stains, battered edges, sticky notes around the top
Have you ever wanted to ask your favorite author why they wrote their book? I recently had the opportunity to interview several of our authors and ask them a series of questions that we are introducing in a new video series called SAS Authors Answer! Over the next few weeks,
The following option can be added to the Metadata Server to default users to a specific DOMAIN. This removes the requirement of using domainusername or username@domain formats for the username field. -authproviderdomain (HOSTUSER:DOMAINNAME) I made this modification within the file: ..Lev1SASMetaMetadataServersasv9_usermods.cfg In SAS Management Console, you must still
I was thrilled about getting the opportunity to attend SAS Global Forum again this year. Not only did I get to spend time visiting lovely Seattle for the first time, but I was able to catch up one-on-one with 21 of our illustrious authors, colleagues, and users—and ask a lot
As I mentioned in a recent post, I've just completed reading Dear Undercover Economist by Tim Harford. I acquired a copy of Tim's book at the SAS Professionals Convention, and I was fortunate enough to meet Tim in person and have him sign the book. He impressed me as very
The F2010 Business Forecasting Conference wrapped up on June 8. Chaired by Tim Rey of Dow Chemical and Jerry Oglesby of SAS, this was another strong event, bringing together 248 forecasters from business, government, and academics, representing 27 states and 11 countries. It was also an opportunity for all to
This week’s assignment? Become masters of SAS Functions! Or at least understand the basics of the most popular ones. Chapter 14 is all about Transforming Data with SAS Functions. We decided to divide this chapter in half due to the length of the chapter and things in our study session
It's that time of year. Caps and gowns, photos and parties. Time to begin a career or go off to college. For those starting a career the learning is over, right? Well, for those of us in the work force we know first-hand, this isn't the reality if you want
Included are some references for using the Libname XML Engine. This can be handy for writing and reading xml. SAS Documentation on the XML Libname for 9.2: http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002594363.htm An example of exporting a SAS dataset using a custom tagset is located at: http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002975327.htm The SAS User Group paper http://www2.sas.com/proceedings/sugi29/119-29.pdf also provides
I spent last week in the UK for the SAS Professionals Convention. It was my first time visiting the UK. If my experience is any indication, then the area (just outside of London) is constantly warm and very bright. However, I did visit very near the summer solstice and I'm
Are you a SAS DATA step programmer? If so, be sure to take advantage of this exclusive "buy 2 books, get 1 free" offer from SAS Publishing. Solutions for SAS Data Step Programmers: The Essential Three-Book Set of Examples from Michele Burlew features 3 of her most popular books, including:
You can export the .sas code from a specific task or the entire project into a .sas file! It's great when publishing a project into a repeatable batch/schedule process. However, be aware of default names for the .sas resulting file. I recently ran across an error when exporting a task
Contributed by Mike Gilliland, Product Marketing Manager Having a job in business forecasting is sort of like being in county lockup – only without the benefit of cuddly bunkmates and weekly delousing. Most of those in the job want out, and those who remain in the field possess psychological maladies
When pages are created, the author can choose the 'rank' which defines the order of tabs for users. (The default is 100.) However, users have the ability to view tabs in this manner or reorder for their viewing pleasure. These options are located within the menu 'Options - Change Page
Contributed by Michele Burlew, president of Episystems Inc. and SAS Press author My SAS writing adventure this summer is a new book that will cover hash object programming. It won’t be very long, maybe 100 pages, and it will have lots of examples. As a longtime SAS programmer, I was
The default web application for the Stored Process system takes you to a lovely screen with introductions and samples. However, wouldn't it be nice to skip this screen to just jump right into the stored processes you have created? For 9.2, change the following URL to include your server/port name. This
This week Christine and I covered chapter 13, “Combining SAS Data Sets.” Most of this material was quite straightforward, and we did surprisingly well on the quiz at the end. But when we came together to discuss the chapter, we realized we both had had issues with one section: the
So you are viewing your SAS Web Report and find that all the data elements capitalizations have changed - instead of no caps or all caps, everything is prop cap (or at least PROPCASE). This is actually a default option in Information Map Studio. To turn it off, select Tools
I'm at the SAS Professionals Convention in Marlow, UK, where over 100 SAS users participated in one of the largest SAS certification events ever held. Also present at the event: a mother duck working to achieve a milestone of her own, by hatching a family of ducklings. According to the
So we are in Web Report Studio, need to create a filter, can't remember the values and want to see them to select them, but the 'Get Values' button is grey'd out? Argh! All that is required is a simple modification to the Information Map. If you go to the
If you send me an e-mail message next week, this is what you can expect in return. Thanks for your e-mail. I'm attending the SAS Professionals Convention in Marlow, UK. That's right, I'm in Merry Old England, the birthplace of William Shakespeare, Charles Dickens, and Ginger Spice, and Doctor Who.
What do you do when you and your spouse are both SAS users, but one of you likes to point-and-click and the other really likes to write SAS programs? Is it possible to share a SAS environment, or are these irreconcilable differences that can lead only to a nasty custody
