DURATION | PRICE | inc-VAT | |
---|---|---|---|
4 | £1,580 | £1,896 | |
The Fast-Track Base Programming course not only provides delegates with a broad understanding of the underlying processing of the language of SAS, but also a breadth of understanding when it comes to programming syntax. This in-depth course is suitable for both the complete novice, and those who have previous exposure to the language of SAS, but who lack formal education on its inner workings. This course covers the curriculum required to sit the SAS Certified Base Programmer for SAS 9 Certification. |
WHAT YOU'LL BE TAUGHT...
An Introduction to the language of SAS
- Program Components
- What are Datasets
- The LIBNAME Statement
Background Concepts
- Syntax Rules
- Datasets
- Naming Conventions
- Dates and Times
- Missing Values
Building Data Steps
- The DATA Statement
- The SET Statement
- Creating New Variables
- Data Step Processing
Introducing Functions
- The SUM Function
- The MEAN Function
- Date Functions
- Character Functions
Selecting Variables and Observations
- KEEPing and DROPing Variables
- The IF Statement
- The WHERE Statement
IF - THEN - ELSE Processing
- IF-THEN-ELSE Syntax
- DO-END Syntax
- The LENGTH Statement
- The OUTPUT Statement
- The DELETE Statement
Sorting Data with PROC SORT
- PROC SORT Syntax
- Creating an Output Dataset
- Removing Duplicate Data
Combining Data
- Combining Data Vertically
- Combining Data Horizontally
Reading Raw Data
- The INFILE Statement
- The INPUT Statement
- Reading Non-Standard Data
- Subsetting Raw Data
Labels and Formats
- Labels
- Supplied Formats
- User-Defined Formats
Frequency Counts with PROC FREQ
- One-Way Frequency Tables
- Two-Way Frequency Tables
- Creating Output Datasets
Summary Statistics with PROC MEANS
- The VAR Statement
- The CLASS Statement
- PROC MEANS Options
The Output Delivery System
- ODS Destinations
- Creating HTML Files
- Creating Datasets
List Reports with PROC PRINT
- PROC PRINT Syntax and Statements
- PROC PRINT Options
- TITLES and FOOTNOTES
Summary Tables with PROC TABULATE
- The TABLE Statement
- One, Two and Three Dimensional Tables
- Creating Multiple Tables
The OUTPUT Statement
- The OUTPUT Statement
- Outputting to Multiple Datasets
- Selecting Observations
- Selecting Variables
Summarising 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
- The PUTLOG Statement
Iterative Processing
- DO Loops
- DO WHILE and DO UNTIL Loops
Array Processing
- Defining an ARRAY
- Using an ARRAY to Create Variables
- ARRAYs with Initial Values
- The TEMPORARY Keyword
- Using an ARRAY with Existing Variables
- Using an ARRAY to Transpose Data
Reading Raw Data
- The INFILE and INPUT Statements
- Fixed-Width Column Data
- Data Errors
- Formatted Data
- INFORMATS
- Detecting Errors
- The DATALINES Statement
- The Single Trailing @
- The Double Trailing @
- Delimited Data
- The DSD Option
WHAT YOU SHOULD ALREADY KNOW...
To be considered for this course, it is recommended that you already have:
- Knowledge of your computer system
- Basic computer literacy
- Some previous programming experience is beneficial, but not essential