Represents the upper echelon of SAS® programmers who demonstrate a high level of proficiency in SAS® programming expertise
This course is for SAS programmers who prepare data for analysis. The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation. It focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with and without macro code are processed. It also covers how to process SAS data using Structured Query Language (SQL).This course helps you prepare you for the following certification exam(s): SAS Certified Advanced Programmer for SAS 9.
Successful candidates should be skilled in tasks such as:
Candidates who earn this credential must have a SAS Certified Base Programmer for SAS®9 credential and then take and pass the SAS Advanced Programming for SAS®9 exam.
Before attending this course, you should have experience using computer software. Specifically, you should be able to
DATA Step and SQL Interfaces
Displaying Query Results
Creating Tables and Views
Advanced PROC SQL Features
Efficient SAS Programming
Controlling I/O Processing and Memory
DATA Step Arrays
DATA Step Hash and Hiter Objects
Combining Data Horizontally
User-Defined Functions and Formats