search: Search support.sas.com KNOWLEDGE BASE     System Requirements     Install Center     Product Documentation     Papers     Samples & SAS Notes     Focus Areas SUPPORT     License Assistance     Administrator Services     Downloads & Hot Fixes LEARNING CENTER     Bookstore     Training     Certification     SAS Learning Edition     Higher Education Resources     SAS OnDemand For Academics COMMUNITY     User Groups     Events     E-Newsletters

• Print |
• E-mail  |
• Bookmark

The Advanced SAS Programming course includes the following e-learning courses: SAS Macro Language, SQL Processing with SAS, Advanced SAS Programming Techniques, and additional lessons on optimizing SAS programs lessons.

You can use SAS 8 or LE 2.0 to take this training, but it is important that you understand that in the practices you will not be able to run any SAS 9 specific SAS programs in your software environment. Any instruction that is specific to SAS 9 is noted in the content, so if you study and understand all the material in the course you will have covered the objectives of the SAS 9 exams.

Learn how to

• use macro code to write more efficient SAS programs
• use the SQL procedure as an easy, flexible way to query and combine your data
• use advanced SAS programming techniques such as creating samples and indexes, using lookup tables to match data, and modifying and tracking data set changes
• write SAS programs to maximize efficiency.

Who should attend

Intermediate to advanced SAS users who use SAS 9 and who want to prepare for the SAS Advanced Programming exam for SAS 9

Approximate duration:  40 hours

License period:  365 days

Before taking this e-learning, you should have taken the SAS Programming 1: Essentials course and the SAS Programming 2: Data Manipulation Techniques course.

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 Samples and 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
Utilizing Best Practices
Selecting Efficient Sorting Strategies
Querying Data Efficiently

Students have unlimited 24/7 access to the interactive multimedia course on the Web for one year. The course requires only a standard Web browser and a free Flash plug-in. The course includes data that can be downloaded, printable lesson summaries, a Quick Reference Guide, practices and solutions, step-by-step demonstrations, and a Certificate of Completion.

This course addresses Base SAS.

You should

• use Internet Explorer 6.0 or later or Firefox 1.5 or later, with JavaScript and cookies enabled
• have the latest version of Macromedia Flash Player installed
• have base SAS software visible on the same machine that you are taking the training on so that you can practice your new skills in your own SAS environment.

.

Share Your Thoughts
If you have suggestions for this course, let us know by adding to our Interest List.



This page was created using SAS software.