Beyond the Basics Using SAS


Author: Kirk Paul Lafler

Publisher: SAS Publishing

A thoroughgoing reference for the issues a SAS user is likely to encounter when using SQL in the SAS environment for database applications. The book covers differences between SAS SQL and ANSI SQL and includes advanced techniques that involve macro language interfaces and performance tuning options.


Paperback (2004–SAS 9.1)


Year: 2004

ISBN: 1-59047-534-8

Pages: 365

Publisher’s list price: 59.95


  • 1. Designing Database Tables
  • 2. Working with Data in PROC SQL
  • 3. Formatting Output
  • 4. Coding PROC SQL Logic
  • 5. Creating, Populating, and Deleting Tables
  • 6. Modifying and Updating Tables and Indexes
  • 7. Coding Complex Queries
  • 8. Working with Views
  • 9. Troubleshooting and Debugging
  • 10. Tuning for Performance and Efficiency
  • Glossary

From the back cover

Master the language of PROC SQL!

Get faster and better results when you use the SQL procedure with this step-by-step, example-driven guide in your hands. You will find information about implementing both American National Standards Institute (ANSI) and non-ANSI features. A broad range of SAS users including applications programmers, database designers and administrators, statisticians, and systems analysts will find techniques to enhance their data access, manipulation, and presentation prowess.

Topics examined include

  • Database design
  • An introduction to SQL, dictionary tables, and tables
  • Coding PROC SQL logic as well as complex queries
  • Working with views
  • Troubleshooting and debugging SQL code
  • Tuning for performance

With the growing popularity of databases, PROC SQL is becoming the language of choice for SAS users around the world. Intermediate and advanced users will appreciate the straightforward explanations and numerous examples. Achieve expert results with the techniques and strategies detailed in PROC SQL: Beyond the Basics Using SAS!