Course Length:
This is a four-day course.
Course Summary:
The Fast-Track Base Programming course not only provides delegates with an understanding of the underlying processing of the language of SAS, but also a breadth of understanding of the programming syntax. This in-depth course will suit both the complete novice, as well as for those who have prior exposure to the language of SAS, but who lack any 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 will 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
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
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
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
PROC Transpose
Using an ARRAY to Transpose Data
Using conditional logic to Transpose Data
An introduction to PROC Transpose
What you should already know:
Knowledge of your computer system
Basic computer literacy
Some previous programming experience is beneficial, but not essential
If the dates below do not suit please contact us on +44 (0)131 225 6952 as alternative dates can be arranged.
Don't Delay - Book Today!
Select a date and click on the button below to register.
Select Course
FTB (Edinburgh) (Monday, 11 Mar 2019 09:00)
FTB (Edinburgh) (Monday, 15 Apr 2019 09:00)
FTB (Edinburgh) (Monday, 29 Apr 2019 09:00)
FTB (Edinburgh) (Monday, 13 May 2019 09:00)
FTB (Edinburgh) (Monday, 17 Jun 2019 09:00)