This paper discusses two little known options of SAS Proc SQL: _method and _tree.
This presentation discusses topics that will help SAS users unlock the many powerful features, options, and other gems found in the SQL universe. Magic options are also presented to alter the way Proc SQL make the joins.
Never use WHERE clause in PROC SQL when joining different tables, use the FROM. This article explain why it's so important from a performance point of view
Comparison between Proc SQL and Data Step
Another comparison between Proc SQL and Data Step
This paper is a combination of several miscellaneous tips and techniques, and sometimes common misconceptions that we have come across when teaching or working with SQL programmers.
In this paper, you will learn how to use PROC SQL statements, options, and clauses to conserve CPU, I/O, and memory resources while accomplishing tasks involving rocessing, ordering, grouping, and summarizing data