Made2Stick Learning

Download the SAS Programming Resource Guide / Course Slides

Why is SAS so easy to learn

Installing SAS Software on your computer - SAS Studio OnDemand Registration

Logging-in to a SAS Session after installation

The SAS User Interface (UI)

Quiz -SAS Programming Interface

Preparing Data - Section Overview

SAS Datasets, Variables and Observations

SAS Libraries

Library Naming Conventions

SAS Dataset naming conventions

SAS Programming syntax

Data step and proc step

Referencing data in SAS

Quiz - SAS Elements

Bringing data into SAS

Bringing data into SAS using the Import Wizard

Bringing data into SAS using LIBNAME statement

Bringing data into SAS using FILENAME statement

Bringing data into SAS

Practice Assignment - Bringing data into SAS

Bringing data into SAS using DELIMITER option

Practice Assignment - 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 the column pointer @ symbol

Bringing data into SAS using the line pointer # symbol

Bringing data into SAS using the line pointer slash symbol

Bringing data into SAS using the trailing @ symbol

Bringing data into SAS using the trailing double @ symbol

Quiz - Bringing data into SAS - Advanced Methods

Practice Assignment - Bringing data into SAS using advanced options

Bringing data into SAS using Proc Import for XLS files

Bringing data into SAS using Proc Import for TXT files

Quiz - Bringing data into SAS using the import procedure

Practice Assignment - Get "berries" data into your SAS session

Creating new variables

Keep, Drop and Rename variables

If-else conditional statements - deriving BMI variable

If-else conditional statements - deriving STATUS variable

Filtering data

Quiz - Conditional Logic and New Variables

Practice Assignment - Conditional logic and filtering data

Practice Assignment - Finding the most expensive cars

SAS dates

SAS Character Functions - Upcase function

SAS Character Functions - Lowcase, Propcase, Len, Cat functions

SAS Character Functions - Substr function

SAS Character Functions -Trim, Left, Strip, Compress, Compbl functions

SAS Character Functions - Scan function

SAS Character Functions - Index functions

SAS Numeric Functions - Sum function

Null Dataset

SAS Numeric Functions - Abs function

SAS Numeric Functions - Ceiling, Floor and Integer Functions

SAS Numeric Functions - Minimum and Maximum functions

Quiz - SAS Dates and Functions

Practice Assignment - Applying SAS Functions

SAS Formats - Introduction

SAS Format Statement

Format Naming Convention

Format using PUT function

Custom format using Proc Format

SAS Informats

Program Data Vector- PDV

PDV Implicit Output

PDV Explicit Output

Do Loops

Quiz on Preparing Data

Mid-Course Rating

Structuring Data - Section Overview

Stacking data using a data step

Stacking data using PROC APPEND

Interleaving data

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

Merging data using Joins-Far 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 - Section Overview

Charts - vertical bar, horizontal bar and Pie chart

Vertical Bar Chart - discrete option

Horizontal Bar Chart - discrete option

Vertical Bar Chart - groups and subgroups

Horizontal Bar Chart - groups and subgroups

Plots

Report Output using PROC PRINT

Report Output using PROC REPORT

Summary stats - PROC FREQ

Summary stats - PROC MEANS

Summary stats - PROC UNIVARIATE

Output Delivery System (ODS) - Reports in HTML, RTF and PDF

ODS with PROC FREQ

ODS with PROC MEANS

ODS with PROC UNIVARIATE

Visualizing Data -Section Conclusion

Optimizing Code - Section Overview

Macro Variables - introduction

Macro Variables - introduction - code

Application of Macro variables

Application of Macro variables - code

Nested macro variables and ampersand resolutions

More on Ampersand resolutions using a cool example

SAS Macros - introduction

SAS Macros - Examples

Macro Functions

Macro Functions - code

Optimizing Code- Section Conclusion