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
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
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
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
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
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
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
So you have an idea to implement queries or changes in the metadata via a program directly using SAS. Well, one of the first items of business is actually to grab the Repository ID number. Included below is some quick reference code on how to query that. PROC METADATA SERVER="my_sas_srv_name"
I am pleased to announce publication of The Business Forecasting Deal: Exposing Myths, Eliminating Bad Practices, Providing Practical Solutions, available now in a convenient carry-everywhere size (approx 6” x 9” x 1”), or for download to your Kindle. Table of contents, sample sections (including the Prologue, Forewords by Tom Wallace
I'm using this post to share links to several SAS-related blogs created by others. This is me acting generous by sharing -- it's not me acting lazy by shirking an original post. Really. Datum Reparo! AnnMaria waves her SAS Enterprise Guide magic wand, utters a few (magic?) words, and makes
Interested in adding a group of users into Metadata w/o Management Console? Included is an example of how to add one user: PROC METADATA SERVER="my_sas_srv_name" PORT=8561 USERID="sasadm@saspw" PASSWORD="xxxxxxxx" PROTOCOL=BRIDGE in="<AddMetadata> <Metadata> <Person Desc='Manager of clinical studies.' Name='Joe E. Doe' Title='Manager of Clinical Studies'> </Person> </Metadata> <Reposid>A0000001.A5VLFKMC</Reposid> <NS>SAS</NS> <Flags>268435456</Flags> <Options/> </AddMetadata>";
Contributed by Paul Allison, Professor of Sociology, University of Pennsylvania I'm happy to announce that the second edition of my book Survival Analysis Using SAS: A Practical Guide has just been published by the SAS Institute. When the first edition was published in 1995, my goal was to provide an
As I make my way around the country I often have the opportunity to talk with state and local government leaders and as you can imagine, the financial crisis is the first, second and third topics on their minds. Everywhere, state and local governments are forced with painful decisions to
"Less Wrong" is the name of the blog where I found this layman's explanation of Bayes' Theorem. As I've pointed out before, I'm not a statistician. But I can comprehend basic statistical explanations such as the explanation of the Monty Hall problem. Understanding the concepts and being able to apply
I presented recently at the County Auditors Association of California annual conference. It was a packed house in Death Valley, CA, and after weathering a major sandstorm, the attendees seemed anxious to learn of the latest fraud trends in local government. Based on the questions and sidebar discussions throughout the
I've known Jim Cox for a long time. He's the SAS R&D manager for SAS Text Miner, and a gifted singer. We almost never talk about work stuff, because Jim is waaaaay too smart for me. That's why I was so pleased to discover Jim's series of blog entries about
The Results Driven Policing Conference, which was put on by the Penn State University Justice and Safety Institute and held in Baltimore recently, showcased the great performance improvements achieved by forward thinking law enforcement agencies throughout the United State and Canada. These agencies are under increasing pressure to improve public
Like any good SAS professional, I subscribe to the SAS Samples RSS feed. The other day I found this sample that shows how to create a PDF report about the contents of a SAS Information Map. It's a nice example: it shows how to use the INFOMAPS engine and ODS
The motto of SAS’ home state gets at what I hope will be a recurring theme of State and Local Connections. How can state and local governments differentiate between what seems to be and what is? How can they move beyond intuition and gut feelings to know the truth? It
As Shane reveals on his blog, your SAS session is equipped to read data that are encoded for all types of machine architectures and locales. ASCII, EBCDIC, 32- or 64-bit, English, Japanese, Greek, Hebrew: the list goes on and on. SAS accomplishes this by using a feature called Cross-Environment Data
Susan and Lora share all of the details on the OpenMic blog. (You can also see it on the SAS Publishing Facebook page.) I was pleased to have reviewed the book for technical content before it was published. As usual, Susan and Lora did a great job; they know what
Why does this SAS program produce an error? proc means data=sashelp.cars mean median min max; by origin; run; It's because SASHELP.CARS is a SAS data set, and SAS data sets observations are stored and processed sequentially, and a BY group operation requires that the observations are already grouped and sorted
Was it the economy? the timing? the location? or the brilliant and good looking Forum panel? That will be for history (or you) to decide. What we do know is that is that the Institute of Business Forecasting’s Best Practices Conference in San Francisco, April 28-30, drew a large and
Contributed by Mike Molter, Principal Statistical Programmer, INC Research I’m writing this from an altitude of 35,000 feet. As I try to squeeze my 6’1” frame into a space clearly designed for passengers no taller than 5 feet while trying to find a place to put my left elbow because
