“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I
Tag: proc sql
Order must be the most frequent cry for help in the SAS classroom. “HELP,” said my student in the classroom. “I work with messy health data. My users want to see data in this order.” T1.col1, t1.col2, t1.col3, t1.col4, t2.col5, t1.col6 and list the remaining columns in column position from
You might have seen my previous blog, where I plotted some interesting tourist attractions on a geographical map of the British Isles (which may be of interest to Analytics 2013 Conference delegates)... Well this blog uses even more powerful analytics, and shows how SAS can calculate the "optimal tour" to visit all
This week's SAS tip is from Kirk Lafler and his book PROC SQL: Beyond the Basics Using SAS. A SAS user since 1979, Kirk often takes his expertise on the road and is a frequent speaker at SAS conferences. He's also currently working on a second edition of the book. If
This week's SAS tip is from master user Phil Holland and his popular book Saving Time and Money Using SAS. If you're not yet familiar with Phil and his extensive work in the user community, start out by visiting his author page. If you're on LinkedIn, look for him on SAS Professional Forum
Kirk Lafler and his book PROC SQL: Beyond the Basics Using SAS are the source of this week's tip. PROC SQL was the very first book that I promoted when joining SAS. Kirk was the perfect first SAS Press author to work with and he remains a favorite. And his book continues to appeal to users--whether they're online or at conferences.
How can you go home on time? Take a quick tour with these 5 tips that I was able to summarize for my students in the SAS SQL 1: Essentials class yesterday. Since they found it handy and asked if it could become a blog post, I thought I’d share
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
As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.” I've always had difficulty solidly learning new programming techniques in a traditional classroom. The new techniques and theories I've learned don’t really take root until I've used them to solve
Consultant Frederick Pratter continues his winning streak with this third edition of Web Development with SAS by Example. Web programmers of all levels will appreciate Frederick's many real-world examples and clean delivery. Speaking of delivery, I'd encourage those of you who attend SAS Global Forum and regional user group conferences to seek out Frederick if