Why learn SAS | Course Introduction and Overview
  • Course Overview
Getting started with SAS Programming
  • Why is SAS so easy to learn
  • SAS Studio through SAS OnDemand - Registration
  • Logging-in to a SAS Session
  • SAS User Interface
  • SAS user interface/ windowing environment
Preparing Data
  • Preparing Data - Section Overview
  • SAS Dataset, Variables and Observations
  • SAS Libraries
  • Library Naming Conventions
  • Dataset Naming Conventions
  • SAS Program Syntax
  • SAS Data Step and Proc Step
  • Referencing data in SAS
  • SAS Elements
  • Bringing data into SAS
  • Brinding data into SAS using the Import Wizard
  • Bringing data into SAS using the LIBNAME statement
  • Bringing data into SAS using the FILENAME statement
  • Bringing data into SAS
  • Bringing data into SAS
  • Bringing data into SAS using DELIMITER option
  • Bringing data into SAS using Delimiter option
  • Bringing data into SAS using DSD option
  • Bringing data into SAS using column input
  • Bringing data into SAS using column pointer @ symbol
  • Bringing data into SAS using the line pointer # symbol
  • Bringing data into SAS using line pointer slash symbol
  • Bringing data into SAS using the trailing @ symbol
  • Bringing data into SAS using the trailing double @ symbol
  • Bringing data into SAS - Advanced Methods
  • Bringing data into SAS using advanced options
  • Bringing data into SAS using Proc Import for XLS (MS Excel) Files
  • Bringing data into SAS using Proc Import for TXT Files
  • Bringing data into SAS using Import procedure
  • Get "berries" data into your SAS session
  • Creating new variables
  • Creating new variables - code
  • Keeping, Dropping and Renaming Variables in a Dataset
  • Conditional logic and filtering data
  • If-else conditional statements - deriving BMI variable
  • If-else conditional statements - deriving STATUS variable
  • Filtering data
  • New variables, conditional logic
  • Finding the most expensive cars
  • SAS Dates
  • SAS Functions - Upcase
  • SAS Functions - Lowcase, Propcase, Len, Cat
  • SAS Functions - Substr
  • SAS Functions -Trim, Left, Strip, Compress, Compbl
  • SAS Dates And SAS Functions
  • Applying SAS Functions
  • SAS Formats - Introduction
  • Format Statement
  • Format Naming Conventions
  • Format using the PUT function
  • SAS Informats
  • SAS Informats - code
  • Custom formats using Proc Format
  • Custom formats using Proc Format - code
  • Formats in SAS
  • Applying SAS formats
  • Program Data Vector (PDV)
  • Implicit Output- Descriptor portion
  • Implicit Output - var and data portion
  • Explicit Output
  • Explicit Output - code
  • Do Loops
  • Behind the scenes
  • Using explicit output statement
  • Preparing data
  • Guided Exercise - "Project Cars" - Introduction
  • Guided Exercise - "Project Cars" - Exercise 1
  • Secret SAS Proc revealed !
  • Preparing data - Section Conclusion
Structuring Data
  • Structuring Data - Section Overview
  • Stacking Data using a Data Step
  • Stacking Data using PROC APPEND
  • Stacking Data using PROC APPEND- code
  • Interleaving of data
  • Stacking of data
  • Sorting Data using PROC SORT
  • Sorting Data using PROC SORT - multi-level sorting
  • Interleaving Data
  • Removing duplicates -NODUP Option
  • Removing duplicates -NODUPKEY Option
  • Sorting data
  • Removing Duplicates
  • Simple merging of data
  • Merging data using Joins - Introduction
  • Merging data using Inner Join
  • Merging data using Inner join - code
  • Merging data using Full Join
  • Merging data using Left Join
  • Merging data using Right Join
  • Merging data using "far" joins