+44 7459 302492
info@uplatz.com
Job Meter = High
Advanced SAS Programming
30 Hours
Online Instructor-led Training
USD 1399 (
About this Course
After of instructor led tuition attendees will be able to:
- Understand the trade-off between writing shorter complex code for the ease of sharing code between programmers;
- Apply best practices in Base SAS Programming;
- Know when to apply and how to manage SAS indexes for Base SAS data sets;
- Use advanced programming within the DATA step;
- Program DATA step object components.
Target Audience
Existing programmers in the SAS language who wish to gain best practice programming knowledge. Those who wish to process efficiently within the DATA step, in addition to configure their SAS environment to maximise data throughput.
-------------------------------------------------------------Advanced SAS Programming
Course Details & Curriculum
AP1 SAS Environment Best Practices
- Organising Your SAS Resources
- Environments & Release Management
- Autoexec Programs and Process Flow
- SAS Libraries & Work Library Space
- SAS System Options
- Automatic Macro Variables
- Workshop Session
AP2 Advanced DATA Step Programming
- Design Patterns for SAS Programs
- Good Programming Practice
- Complexity vs Clarity
- Advanced Programming Techniques
- Workshop Session
AP3 Data Organisation
- SAS Indexes
- SAS Views
- Compression
- Generation Data Sets (Optional)
- Audit Trails (Optional)
- Workshop Session
AP4 Advanced SAS Statements
- The MODIFY Statement
- The LOCK Statement
- The SASFILE Statement
- The FILENAME Statement
- Workshop Session
AP5 Using Hash Tables
- Introduction to Hash Objects in the DATA Step
- Declaring and Using a Hash Object
- Declaring and Using a Hash Iterator Object
- Hash and Hash Iterator Object Attributes and Methods
- Workshop Session
AP6 Table Lookups
- Introduction
- Match Merge
- Hash Join
- SQL Join
- Using Formats
- Using Indexes
- Other Techniques with Joins
- Techniques for Subsetting Data
- Guidelines
- Workshop Session
AP7 User-Defined Functions with Proc FCMP
- Introduction to Proc FCMP
- Functions
- Subroutines
- SAS Syntax in the Proc FCMP Environment
- RUN_MACRO and RUN_SASFILE (Optional)
- Workshop Session
AP8 Efficiency
- What is Efficiency?
- Diagnosing Performance Issues
- I/O Performance
- Sorting Data
- Efficient use of Storage Space
- Efficient Programming Practices
- Workshop Session
AP9 Perl Regular Expressions (optional)
- Introducing Regular Expressions
- Further Regular Expression Syntax
- Changing Text Using PRXCHANGE
- Further Matching Facilities (Optional)
- Additional Features (Optional)
- Workshop Session
