The first line of this week's SAS tip grabs your attention, "PROC SQL provides a helpful (though potentially dangerous) tool in the form of the DESCRIBE TABLE statement." SAS author, consultant, and member of the SAS-L Hall of Fame Howard Schreier included this intriguing statement in his book PROC SQL by Example: Using
Tag: data step
Art Carpenter’s newest book, Carpenter’s Guide to Innovative SAS Techniques, offers advanced SAS programmers an all-in-one programming reference that includes advanced topics not easily found outside the depths of SAS documentation or more advanced training classes. No matter how you approach the use of SAS software, the techniques provided in
In the Star Wars movie, Obi-wan could just wave his hand, mutter a few words, and the stormtroopers would "move along". How the power of the Force makes ridding yourself of problematic characters so much easier! I recently was invited to become an alternate instructor for Ron Cody’s SAS Business
Picture this – a student grabs the Programming 1 textbook, scans it quickly seemingly searching for something specific, and shakes his head indicating an unsuccessful search. He plants himself smack dab in the front row, looks me squarely in the eye, raises one eyebrow quizzically and says, “Bad words?” I
In my last blog post, I discussed how to use SAS options to send unattended email using an SMTP server. In this segment, I’ll tackle creating “pretty” email (using HTML) and sending out emails with attachments. First, I produced a basic report using ODS. I liked the look, and set
I’m responsible for a SAS program that runs nightly in batch on a Linux server here at SAS. I am also a road warrior, and routine status checking via a remote connection is often tricky, and sometimes impossible due to unstable hotel internet connections. So I thought “Why can’t SAS just
When I joined SAS Institute I had no knowledge of SAS. I studied, researched and practiced. The questions I asked would make even the most seasoned programmer blush a beetroot red! Those were an intense nine months—I’ll tell you more in a later post about the learning system at SAS
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:
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
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