SAS Certification Prep Guide: Advanced Programming for SAS 9, Fourth Edition
- 12h 15m
- SAS Institute
- SAS Institute
- 2014
Businesses rely on career professionals with strong SAS knowledge and skills. Set yourself apart from the competition by earning the only globally recognized credential endorsed by SAS.
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.
New or experienced SAS users will find this guide to be an invaluable resource that covers the objectives tested on the exam. The text contains quizzes that enable you to test your understanding of material in each chapter. Quiz solutions are included at the end of the book. Candidates must earn the SAS Certified Base Programmer for SAS 9 Credential before taking the SAS Advanced Programming for SAS 9 exam.
You’ll find instructions on how to obtain sample data when accessing SAS through SAS Enterprise Guide, SAS Studio, SAS University Edition, and the SAS windowing environment. This edition provides significant improvements to numerous examples, making the code even more efficient.
Experience is a critical component to becoming a SAS Certified Professional. This comprehensive guide along with training in SAS SQL1, SAS Macro Language 1, and SAS Programming 3 are valuable resources designed to help you prepare for the Advanced SAS Certification exam.
In this Book
-
Performing Queries Using PROC SQL
-
Performing Advanced Queries Using PROC SQL
-
Combining Tables Horizontally Using PROC SQL
-
Combining Tables Vertically Using PROC SQL
-
Creating and Managing Tables Using PROC SQL
-
Creating and Managing Indexes Using PROC SQL
-
Creating and Managing Views Using PROC SQL
-
Managing Processing Using PROC SQL
-
Introducing Macro Variables
-
Processing Macro Variables at Execution Time
-
Creating and Using Macro Programs
-
Storing Macro Programs
-
Creating Indexes
-
Combining Data Vertically
-
Combining Data Horizontally
-
Using Lookup Tables to Match Data
-
Formatting Data
-
Modifying SAS Data Sets and Tracking Changes
-
Introduction to Efficient SAS Programming
-
Controlling Memory Usage
-
Controlling Data Storage Space
-
Using Best Practices
-
Querying Data Efficiently
-
Creating Functions with PROC FCMP
