All Posts
Art Carpenter offers tremendous advice to SAS programmers who want to maximize their job security: make your programs impossible for others to read and understand. In his published papers, Art (in his tongue-in-cheek manner) presents practical examples for how to accomplish this. I'm afraid that with our new code formatter
Have you ever inherited a SAS program from a "gifted" SAS programmer? By "gifted", I mean a person who regards line feeds and white space as a waste of precious bytes, who knows that his program is worth the tremendous effort it might take to read and understand it, as
I come across many government agencies that are tackling very important issues (i.e. fraud & improper payments, bio-surveillance, patient outcomes, etc.) using rules, basic analytics and intuition. These are techniques that have been used successfully for years especially when government was smaller, the dollars involved were less significant, and the
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
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
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
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
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
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
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
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
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