SAS Certification Prep Guide: Advanced Programming for SAS 9

Author: SAS (technical reference)

Publisher: SAS Institute

Spend weeks studying important advanced techniques of SAS programming in the business environment with this official study guide, focusing specifically on SQL, macro language, and efficiency. This book is especially for readers who have completed the SAS Certified Base Programmer exam and want to expand on their understanding of the SAS environment and SAS programming techniques to prepare for the next certification exam.

Editions

1 Paperback and CD-ROM (2007)

2 Paperback (2009)

3 Paperback (2011)

3 Paperback

Year: 2011

ISBN: 978-1-60764-925-0

Publisher’s list price: 129.00

2 Paperback

Year: 2009

ISBN: 978-1-60764-044-8

Publisher’s list price: 129.00

1 Paperback and CD-ROM

Year: 2007

ISBN: 978-1-59994-559-0

Pages: 991

Publisher’s list price: 129.00

Contents

• 1. Performing Queries Using PROC SQL
• 2. Performing Advanced Queries Using PROC SQL
• 3. Combining Tables Horizontally Using PROC SQL
• 4. Combining Tables Vertically Using PROC SQL
• 5. Creating and Managing Tables Using PROC SQL
• 6. Creating and Managing Indexes Using PROC SQL
• 7. Creating and Managing Views Using PROC SQL
• 8. Managing Processing Using PROC SQL
• 9. Introducing Macro Variables
• 10. Processing Macro Variables at Execution Time
• 11. Creating and Using Macro Programs
• 12. Storing Macro Programs
• 13. Creating Samples and Indexes
• 14. Combining Data Vertically
• 15. Combining Data Horizontally
• 16. Using Lookup Tables to Match Data
• 17. Formatting Data
• 18. Modifying SAS Data Sets and Tracking Changes
• 19. Introduction to Efficient SAS Programming
• 20. Controlling Memory Usage
• 21. Controlling Data Storage Space
• 22. Utilizing Best Practices
• 23. Selecting Efficient Sorting Strategies
• 24. Querying Data Efficiently
• 22. Utilizing Best Practices
• Quiz Answer Keys
• Index