PROC SQL vs. DATA Step Programming

Everyone wants to know: Should I use the DATA step or PROC SQL to join this data? Take a behind the scenes look at how the DATA step and SQL procedure process data by comparing all types of joins (inner, left/right, outer) with multiple types of data (one-to-one, one-to-many, many-to-many).

Top 10 Ways to Optimize Your SAS Code

Learn tips and tricks to make you SAS code run more efficiently no matter what size server you are on. There are at least 6 ways to do most things in SAS so knowing some coding alternatives always helps. Tips range from accessing data in any form to choosing the best procedure to process you data and everything in between.

About the Presenter

Ron Coleman has been with SAS for 16 years and resides in Jacksonville, FL, with his wife Sandy. Ron started using SAS in 1984 doing climatology and atmospheric physics for the United States Air Force. He has also worked in many different industries including banking, credit, insurance, and manufacturing both as an employee and as a private consultant.  Ron joined SAS in 2003 and is currently with the Health and Life Sciences Analytics team at SAS. In addition to working directly with customers, he has also given numerous presentations to international, regional and local SAS user conferences since 1991.