| Introduction and Overview |
|
Course Overview |
|
00:05:00 |
|
Why SAS |
|
00:02:00 |
| Getting started with SAS Programming |
|
Why is SAS so easy to learn |
|
00:01:00 |
|
SAS Studio through SAS OnDemand- Registration |
|
00:05:00 |
|
Logging-in to SAS after installation |
|
00:01:00 |
|
SAS Interface and windows |
|
00:01:00 |
| Preparing Data |
|
Preparing Data – Section Overview |
|
00:11:00 |
|
SAS Dataset, Variables and Observations |
|
00:04:00 |
|
SAS Libraries |
|
00:02:00 |
|
Lib Naming Conventions |
|
00:12:00 |
|
Dataset Naming Conventions |
|
00:11:00 |
|
SAS Program Syntax |
|
00:10:00 |
|
SAS Data Step and Proc Step |
|
00:11:00 |
|
Referencing data in sas |
|
00:08:00 |
|
Bringing data into SAS using Proc Import txt |
|
00:03:00 |
|
Bringing data into SAS using Import Wizard |
|
00:09:00 |
|
Bringing data into SAS using LIBNAME statement |
|
00:01:00 |
|
Bringing data into SAS using FILENAME |
|
00:03:00 |
|
Bringing data into SAS using DELIMITER option |
|
00:01:00 |
|
Bringing data into SAS using DSD option |
|
00:03:00 |
|
Bringing data into SAS using column input |
|
00:01:00 |
|
Bringing data into SAS using the column pointer |
|
00:14:00 |
|
Bringing data into SAS using the line pointer |
|
00:01:00 |
|
Bringing data into SAS using the line slash |
|
00:09:00 |
|
Bringing data into SAS using the trailing |
|
00:01:00 |
|
Bringing data into SAS using the trailing double |
|
00:05:00 |
|
Bringing data into SAS using Proc Import xls |
|
00:02:00 |
|
Bringing data into SAS using Proc Import txt |
|
00:03:00 |
|
Creating new variables |
|
00:03:00 |
|
Creating new variables – code |
|
00:04:00 |
|
Keeping, Dropping and Renaming Variables in a Dataset |
|
00:01:00 |
|
If-else conditional statements – deriving BMI variable |
|
00:06:00 |
|
If-else conditional statements – deriving status variable |
|
00:01:00 |
|
Filtering data |
|
00:09:00 |
|
SAS Dates |
|
00:05:00 |
|
SAS Functions – Upcase |
|
00:05:00 |
|
SAS Functions – Lowcase, Propcase, Len, Cat |
|
00:05:00 |
|
SAS Functions – Substr |
|
00:07:00 |
|
SAS Functions – Substr |
|
00:07:00 |
|
SAS Formats – Introduction |
|
00:05:00 |
|
SAS Format Statement |
|
00:12:00 |
|
Format Naming Convention |
|
00:04:00 |
|
Format using the PUT function |
|
00:06:00 |
|
SAS Informats |
|
00:06:00 |
|
SAS Informats – code |
|
00:04:00 |
|
Custom formats using Proc Format |
|
00:08:00 |
|
Custom formats using Proc Format – code |
|
00:05:00 |
|
Program Data Vector- PDV |
|
00:02:00 |
|
Implicit Output- Descriptor portion |
|
00:08:00 |
|
Implicit Output – var and data portion |
|
00:03:00 |
|
Explicit Output |
|
00:04:00 |
|
Explicit Output – code |
|
00:03:00 |
|
Do Loops |
|
00:07:00 |
|
Project Cars- Introduction |
|
00:05:00 |
|
Project Cars- Assignment 1- Statement |
|
00:05:00 |
|
Project Cars- Assignment 1 – Solution |
|
00:09:00 |
|
Module Conclusion-preparing data |
|
00:03:00 |
| Structuring Data |
|
Structuring Data – Section Overview |
|
00:05:00 |
|
Stacking Data using a Data Step |
|
00:12:00 |
|
Stacking Data using PROC APPEND |
|
00:12:00 |
|
Stacking Data using PROC APPEND- code |
|
00:07:00 |
|
Interleaving of data |
|
00:10:00 |
|
Sorting Data using PROC SORT |
|
00:08:00 |
|
Sorting Data using PROC SORT – multi-level sorting |
|
00:05:00 |
|
Removing duplicates -NODUP Option |
|
00:13:00 |
|
Removing duplicates -NODUP Option |
|
00:13:00 |
|
Simple merging of data |
|
00:06:00 |
|
Merging data using Joins-Introduction |
|
00:10:00 |
|
Merging data using Inner Join |
|
00:09:00 |
|
Merging data using Inner join – code |
|
00:07:00 |
|
Merging data using Full Join |
|
00:08:00 |
|
Merging data using Left Join |
|
00:06:00 |
|
Merging data using Right Join |
|
00:12:00 |
|
Merging data using “far” joins |
|
00:06:00 |
|
PROC SQL – ing data |
|
00:05:00 |
|
Proc SQL – ing data – code |
|
00:10:00 |
|
PROC SQL – filtering data |
|
00:06:00 |
|
PROC SQL – sorting data |
|
00:12:00 |
|
PROC SQL – removing duplicates |
|
00:05:00 |
|
Transposing data – ID Statement – code |
|
00:02:00 |
|
Transposing data – ID Statement – code |
|
00:02:00 |
|
Transposing data – BY statement |
|
00:05:00 |
|
Transposing data – BY statement – code |
|
00:02:00 |
|
Retain Statement – Introduction |
|
00:02:00 |
|
Retain Statement – how to use |
|
00:06:00 |
|
Retain Statement – Example |
|
00:08:00 |
|
Project Cars- Assignment 2- Statement |
|
00:07:00 |
|
Project Cars- Assignment 2- Solution |
|
00:10:00 |
|
Conclusion structuring data |
|
00:08:00 |
| Visualizing Data |
|
Visualizing Data – Section Overview |
|
00:07:00 |
|
Charts – Introduction – Vertical Bar Chart |
|
00:12:00 |
|
Charts – Horizontal Bar and Pie Charts |
|
00:11:00 |
|
Vertical bar chart – DISCRETE option |
|
00:09:00 |
|
Horizontal bar chart – DISCRETE option |
|
00:08:00 |
|
Vertical bar chart – groups and subgroups |
|
00:09:00 |
|
Horizontal bar chart – groups and subgroups |
|
00:08:00 |
|
Plots |
|
00:08:00 |
|
Report Output using PROC PRINT |
|
00:07:00 |
|
Report Output using PROC REPORT – DISPLAY option |
|
00:04:00 |
|
Report Output using PROC REPORT – ORDER & GROUP option |
|
00:07:00 |
|
Summary statistics – PROC FREQ |
|
00:09:00 |
|
Summary statistics – PROC MEANS |
|
00:05:00 |
|
Summary statistics – PROC UNIVARIATE |
|
00:07:00 |
|
Output Delivery System (ODS) – Report Formats |
|
00:09:00 |
|
ODS with Proc Freq |
|
00:06:00 |
|
ODS with Proc Means |
|
00:04:00 |
|
ODS with Proc Univariate |
|
00:09:00 |
|
Project Cars- Assignment 3- Statement _ i21F001 |
|
00:10:00 |
|
Project Cars- Assignment 3- Solution |
|
00:05:00 |
|
Conclusion visualizing data |
|
00:08:00 |
| Optimizing Code |
|
Optimizing Code – Section Overview |
|
00:07:00 |
|
Macro Variables – Introductionduction |
|
00:09:00 |
|
Macro Variables – Introductionduction – code |
|
00:02:00 |
|
Application of Macro variables |
|
00:06:00 |
|
Application of Macro variables – code |
|
00:01:00 |
|
Nested macro variables and ampersand resolutions |
|
00:01:00 |
|
More on Ampersand resolutions using a cool example |
|
00:05:00 |
|
SAS Macros – Introductionduction |
|
00:05:00 |
|
SAS Macros – Examples |
|
00:10:00 |
|
Macro Functions |
|
00:02:00 |
|
Macro Functions – code |
|
00:12:00 |
|
Project Cars- Assignment 4- Statement |
|
00:04:00 |
|
Project Cars- Assignment 4- Solution |
|
00:05:00 |
|
Conclusion optimizing code |
|
00:07:00 |
| Practice Exercise | Case Study |
|
Project Heavy-weight – Introduction |
|
00:08:00 |
|
Project heavy-weight- Project 1 – Solution |
|
00:09:00 |
|
Project heavy-weight- Project 1 – Solution |
|
00:09:00 |
|
Project Heavy-weight – Project 2 – Statement |
|
00:04:00 |
|
Project Heavy-weight -Project 2 – Solution |
|
00:03:00 |
|
Project Heavy-weight – Project 3 – Statement |
|
00:03:00 |
|
Project Heavy-weight – Project 3 – Solution |
|
00:05:00 |
