SAS Publications

Publications about SQL Optimization

  • Powerful and Hard-to-find PROC SQL Features
  • 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.

  • Efficiency Techniques for Beginning PROC SQL Users
  • 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