Experience is a critical component to becoming a SAS Certified Professional. The SAS Certification Prep Guide: Advanced Programming for SAS 9, Fourth Edition, prepares you to take the Advanced Programming for SAS 9 exam. Major topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs, as well as a new chapter on creating functions with PROC FCMP. You will also become familiar with the enhancements and new functionality that are available in SAS 9.
Part 1. SQL Processing with SAS
Chapter 1. Performing Queries Using PROC SQL
Chapter 2. Performing Advanced Queries Using PROC SQL
Chapter 3. Combining Tables Horizontally Using PROC SQL
Chapter 4. Combining Tables Vertically Using PROC SQL
Chapter 5. Creating and Managing Tables Using PROC SQL
Chapter 6. Creating and Managing Indexes Using PROC SQL
Chapter 7. Creating and Managing Views Using PROC SQL
Chapter 8. Managing Processing Using PROC SQL
Part 2. SAS Macro Language
Chapter 9. Introducing Macro Variables
Chapter 10. Processing Macro Variables at Execution Time
Chapter 11. Creating and Using Macro Programs
Chapter 12. Storing Macro Programs
Part 3. Advanced SAS Programming Techniques
Chapter 13. Creating Indexes
Chapter 14. Combining Data Vertically
Chapter 15. Combining Data Horizontally
Chapter 16. Using Lookup Tables to Match Data
Chapter 17. Formatting Data
Chapter 18. Modifying SAS Data Sets and Tracking Changes
Part 4. Optimizing SAS Programs
Chapter 19. Introduction to Efficient SAS Programming
Chapter 20. Controlling Memory Usage
Chapter 21. Controlling Data Storage Space
Chapter 22. Using Best Practices
Chapter 23. Querying Data Efficiently
Chapter 24. Creating Functions with PROC FCMP
