Life saver tip for comparing PROC SQL join with SAS data step merge

“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 […]

Post a Comment

Getting things in order with PROC SQL, macro and a SAS function

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 […]

Post a Comment

Real-world analytics for Analytics 2013!

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 […]

Post a Comment

SAS author's tip: Adding data with a SELECT query

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 […]

Post a Comment

SAS author's tip: Converting SAS/ACCESS view descriptors to SQL views

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 […]

Post a Comment

SAS author's tip: displaying integrity constraints

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. […]

Post a Comment

Go home on time with these 5 PROC SQL tips

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 […]

Post a Comment

SAS author's tip: Help from the DESCRIBE TABLE statement

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 […]

Post a Comment

Jedi SAS Tricks: Some Experience Required

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 […]

Post a Comment

SAS author’s tip: SQL pass-through

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 […]

Post a Comment