Designing database tables -- Working with data in PROC SQL -- Formatting output -- Coding PROC SQL logic -- Creating, populating and deleting tables -- Modifying and updating tables and indexes -- Coding complex queries -- Working with views -- Troubleshooting and debugging -- Tuning for performance and efficiency.
Summary
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 this volume's straightforward explanations and numerous examples. Readers can achieve expert results with the techniques and strategies detailed in "PROC SQL: Beyond the Basics Using SAS."