| DURATION | PRICE | inc-VAT | |
|---|---|---|---|
| 3 | £1,305 | £1,566 | |
The Base Certification Review course is the perfect way to refresh the minds of those who have undergone either Newtyne's Foundations and Data Step Techniques or the Fast-Track Base Programming training (or their equivalents) but do not use all of the certification topics on a day-to-day basis. Importantly, when new software versions bring additional functions and features, we ensure seasoned programmers are fully aware of them. Newtyne's experienced Instructors will close gaps in knowledge and provide the best chance of attaining certification. | |||
WHAT YOU'LL BE TAUGHT...
Combining Data
- Joining Data Sets Vertically
- Data Set Options - RENAME= FIRSTOBS= OBS= IN=
- Joining Data Sets Horizontally - Match-Merging
The Output Delivery System
- ODS Destinations
- Creating HTML files with ODS
- Creating Excel files with ODS
- Creating a Data Set with ODS
Manipulating Data using Functions
- Transforming Character Data
- Transforming Numeric Data
- Transforming Dates
Reading Raw Data using INFILE and INPUT
- Reading Columnar Data
- Reading Formatted Data
- Reading Delimited Data
- The DATALINES Statement
- Conditionally Reading Data
- The Single Trailing @
- The Double Trailing @
WHAT YOU SHOULD ALREADY KNOW...
To get the most out of this course, it is is vital that you can already:
- read from and write to external raw data files
- perform character and numeric data manipulations
- join data sets vertically and horizontally
- use procedures to generate list reports
- use procedures to generate summary reports
- use diagnostic tools and LOG messages to identify and correct errors in program code
