Many analysts, including me, use PROC SQL extensively in the early stages of analysis. One can often accomplish in a single SQL query things that take several sorts and uses of the data step. Also tasks can often be accomplished with much less and clearer code.
The following video presents a brief introduction to the features of Proc SQL that I use regularly in analytic projects