| DURATION | PRICE | inc-VAT | |
|---|---|---|---|
| 2 | £790 | £948 | |
Building on the learnings provided in the Foundations course, the Data Step Techniques course provides Learners with an immediately useful armoury of new statements and functions. | |||
WHAT YOU'LL BE TAUGHT...
Introduction
- Course Data
- Review of 'Foundations - The Language of SAS;
Sorting Data with PROC SORT
- PROC SORT Syntax
- Creating an Output Dataset
- Removing Duplicate Data
Summarizing Observations
- The RETAIN Statement
- The SUM Statement
- BY-GROUP Processing
Manipulating Data using Functions
- Transforming Character Variables
- Transforming Numeric Variables
- Transforming Date Variables
- Changing Variable Type
Debug programs using PUT Statements
- The PUT Statement
Iterative Processing
- DO Loops
- DO WHILE and DO UNTIL Loops
Formats
- Supplied Formats
- User Defined Formats
WHAT YOU SHOULD ALREADY KNOW...
To get the most out of the course, it is expected that you should have attended the Foundations: The Language of SAS course (or comparable course of study). If not, it is vital that you have completed six months of developing code in the language of SAS, including:
- Building DATA and PROC steps
- Character, Numeric and Date functions
- KEEP and DROP to select variables
- IF and WHERE statements to select observations
- Conditional Processing with IF-THEN-ELSE
- Combining Data Sets vertically and horizontally
- Summarising data with the FREQ, MEANS and TABULATE procedures
