This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Simplest Guide to SAS Programming | SAS Base | SAS Advanced
Introduction
Why learn SAS (1:34)
Course Overview (0:44)
Getting started with SAS Programming
Why is SAS so easy to learn (2:45)
Installing SAS Software on your computer (10:21)
Logging-in to a SAS session after installation (0:42)
SAS User interface and windowing environment (5:59)
Preparing Data
Preparing Data - introduction (0:05)
SAS Datasets, Variables and Observations (8:44)
SAS Libraries (4:50)
Library Naming Conventions (4:48)
Dataset Naming Conventions (4:05)
SAS Program Syntax (6:57)
Data Step and Proc Step (2:47)
Referencing Data in SAS (4:47)
Bringing data into SAS (16:01)
Bringing data into SAS using FILENAME statement (5:09)
Bringing data into SAS using LIBNAME statement (5:21)
Bringing data into SAS using DELIMITER option (3:19)
Bringing data into SAS using DSD option (7:36)
Bringing data into SAS using COLUMN input (4:02)
Bringing data into SAS using COLUMN pointer @ symbol (1:53)
Bringing data into SAS using LINE pointer # symbol (7:10)
Bringing data into SAS using LINE pointer slash symbol (2:24)
Bringing data into SAS using the Trailing @ symbol (3:09)
Bringing data into SAS using the Trailing double @ symbol (2:26)
Creating new variables
If-else conditional statements
Filtering Data
SAS Dates (6:48)
SAS Functions - Upcase, Lowcase, Propcase, Length, Cat (22:12)
SAS Functions - Substr, Trim, Left, Strip, Compress, Compbl (17:16)
SAS Formats - introduction (3:37)
SAS Format statement (6:35)
Format Naming Convention (10:26)
Format using Put function
Proc Format
SAS Informats
Program Data Vector (PDV)
PDV Implicit Output (14:34)
PDV Explicit Output
Structuring Data
Structuring data - introduction (0:09)
Stacking data using a Data Step
Stacking data using Proc Append (14:38)
Interleaving data (9:02)
Sorting data using Proc Sort
Removing duplicates-NODUP option
Removing duplicates-NODUPKEY option
Simple Merging of data
Merging data using Joins-Introduction
Merging data using joins-Inner Join
Merging data using Joins-Full Join
Merging data using Joins-Left Join
Merging data using Joins-Right Join (3:41)
Merging data using Joins-Far Joins
Proc SQL - copying data
Proc SQL - filtering data
Proc SQL - sorting data
Proc SQL - removing duplicates
Proc SQL - inner join
Proc SQL - full join (7:42)
Proc SQL - left and right joins
Transposing data using ID statement
Transposing data using BY statement
Retain Statement - introduction
Retain Statement - how it is used
Retain Statement - an example
Visualizing Data
Visualizing data - intro (0:06)
Charts - vertical bar, horizontal bar and Pie chart (11:19)
Vertical Bar Chart - discrete option (9:43)
Horizontal Bar Chart - discrete option (1:34)
Vertical Bar Chart - groups and subgroups
Horizontal Bar Chart - groups and subgroups
Plots
Report output using PROC PRINT (6:06)
Report output using PROC REPORT
Summary Statistics - PROC FREQ
Summary Statistics - PROC MEANS
Summary Statistics - PROC UNIVARIATE
Output Delivery System (ODS) - Reports in HTML, RTF and PDF
ODS with PROC FREQ
ODS with PROC MEANS (1:48)
ODS with PROC UNIVARIATE
Visualizing data - intro
Complete and Continue
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
