| DURATION | PRICE | inc-VAT | |
|---|---|---|---|
| 7 hours | £425 | £510 | |
The Advanced Efficiencies course covers a number of best practice coding techniques that will enable you to optimise the use of CPU Time, Working Memory and Data Storage resources to make you stand out from the crowd. | |||
WHAT YOU SHOULD ALREADY KNOW...
In order to gain a suitable understanding from this course, it is expected that you should have attended the, 'Foundations: The Language of SAS' and 'Data Step Techniques: The Language of SAS' courses (or a comparable course of study), or have completed nine months of developing code in the Language of SAS covering topics including:
- Use of Global statements e.g. LIBNAME FILENAME and OPTIONS
- Access data sources including Data Sets and external files
- Use of functions to transform character data (e.g. SCAN, FIND, SUBSTR)
- Use of functions to transform numeric data (e.g. CEIL, INT, FLOOR, ROUND)
- Use of functions to transform dates (e.g. DAY, MONTH, YEAR, INTCK)
- KEEP and DROP to select variables
- IF and WHERE statements to select observations
- Conditional Processing with IF-THEN-ELSE
- IterativeDOLoops
- ConditionalDoLoops-DOWHILE,DOUNTIL
- Compile-Time statements (e.g. LENGTH, RETAIN)
- CombiningDataSetsverticallyandhorizontally
- Summarizing data with the FREQ, MEANS and TABULATE procedures
WHAT YOU'LL BE TAUGHT...
Introduction
- Optimizing Task Processing
- Understanding how to measure efficiencies
- Understanding efficiency trade-offs
- Deciding which efficiency options to choose
- Measuring Resource Usage
Dataset Pages and I/O Processing
- Data Set Pages - Attributes
- Data Set Pages - I/O Processing
- Efficiency Savings with I/O
Numeric Data Storage and Compressing Datasets
- Numeric Data Storage
- Reducing the length of Numeric Variables
- Attributes of a Compressed Data Set
- Compressing a Data Set
- Comparing Compression Algorithms
- Advantages and Disadvantages
Creating and Using Indexes
- UnderstandingIndexes
- Creating Indexes using:
- Data Step -ProcDatasets
- Proc SQL -Using Indexes
Efficient Program Code
- Coding choices for Program Efficiencies
- Do not process data un-necessarily
- Reduce the number of steps in program code
- Reduce the number of functions
- UsetheMacroProcessingFacility
