|
SAS Programmers who wish to write efficient SAS Programs and fine-tune
their existing Programs.
This course is designed to enhance existing SAS programming skills
and improve the efficiency of your programs. Many different efficiency techniques are studied in depth through practical examples.
To take this course, you should have taken the Fundamentals of the
SAS System course and have at least 6 months SAS programming experience.
1 day.
|
Benchmarking
CPU, I/O and Memory
Reducing Disk Space
|
SAS Engines
Space Reduction
Data Set Compression
Workshop Session
|
|
When to use indexes
Creating and Deleting Indexes
Index Advantages and Disadvantages
Workshop Session
|
Data Library Structure
Multi-Engine Architecture
Proc Access
Stored Program Facility
Data Step Views
|
|
Lookups using Formats
Lookups using Indexes
Lookups using Merges
Lookups using Arrays
Lookups using SQL Joins
Lookups using Macros
Workshop Session
|
The Where Clause
Keep and Drop
Other Data Set Options
Workshop Session
|
|
Working with Duplicate
Controlling Secondary Sort Orders
Using the Sort Flag
SAS Sort Vs the Hot Sort
Workshop Session
|
|
|
