Duration: 40 hrs
Fee: 15,000 INR
The next level for SAS Base Programmer for SAS 9 certified professionals and the foundation for many job roles includes programmers, analysts, data managers, or anyone writing SAS programs to access and manage data to perform queries and analyses
Successful candidates should be skilled in tasks such as
- using advanced DATA step programming statements and efficiency techniques to solve complex problems
- writing and interpreting SAS SQL code
- creating and using the SAS MACRO facility.
To discuss any of these capabilities further, please contact us.
Syllabus Content:
SAS Macro Language
- Introducing Macro Variables
- Processing Macro Variables at Execution Time
- Creating and Using Macro Programs
- Storing Macro Programs
SQL Processing with SAS
- 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
Advanced SAS Programming Techniques
- 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
Optimizing SAS Programs
- Introduction to Efficient SAS Programming
- Controlling Memory Usage
- Controlling Data Storage Space
- Utilizing Best Practices
- Selecting Efficient Sorting Strategies
- Querying Data Efficiently
Please contact us to discuss your requirements further.