Advanced SAS Course by Solving Questions and Use Cases

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Introduction

Chapter 2: Introduce video and downloadable files

Lecture 1: How to use the course materials

Chapter 3: Walk through each question and case by explanation

Lecture 1: Learn first SAS Macro function and variable

Lecture 2: Understand Macro evaluation function and usages

Lecture 3: Understand Macro evaluation function and usages (Cont.)

Lecture 4: Understand %scan function and application

Lecture 5: Learn %index(), %scan() and SAS Macro programming

Lecture 6: Length statement in data step programming and usages

Lecture 7: Learn how to join tables using SAS SQL

Lecture 8: Learn how to transfer parameters to SAS Macro functions

Lecture 9: Learn application by combining SAS SQL and Macro functions

Lecture 10: Understand ways for Resolving Macro variables

Lecture 11: Macro Do Loop and output

Lecture 12: Proc SQL and aggregation functions

Lecture 13: Alter names of data sets and proc datasets

Lecture 14: Proc SQL, aggregation function and subquery

Lecture 15: BUFSIZE and BUFNO options in data steps

Lecture 16: A practical and typical examples of SAS SQL (a)

Lecture 17: A practical and typical examples of SAS SQL (b)

Lecture 18: Automatic SAS Macro variables and usages

Lecture 19: Automatic SAS Macro variables and usages (Cont.)

Lecture 20: SAS SQL to join tables

Lecture 21: SAS SQL product join

Lecture 22: Data step function and format

Lecture 23: SAS internal macro function and application

Lecture 24: SAS internal macro function and application (Cont.)

Lecture 25: SAS internal macro function and application (Cont.)

Lecture 26: Extract data structures into Macro variables using Proc SQL

Lecture 27: Create index for SAS data set

Lecture 28: Create SAS macro function to export data

Lecture 29: Introduce REUSE option

Lecture 30: Understand %eval Macro function and %do loop

Lecture 31: Learn SAS PROC SQL and output

Lecture 32: Learn how to resolve multiple Macro variables

Lecture 33: Learn how to debug SAS Macro programs

Lecture 34: A comprehensive example of SAS macro program

Lecture 35: Learn case statement in PROC SQL

Lecture 36: Understand function of of index in SAS data sets

Lecture 37: Learn how to create index for SAS data sets

Lecture 38: Using SQL to generate index of SAS tables

Lecture 39: Learn how rename can change index in data step

Lecture 40: Understand label and format options in PROC SQL

Lecture 41: Learn SQL functions in SAS PROC SQL

Lecture 42: Query by passing Macro variable into SQL

Lecture 43: Query missing values using PROC SQL

Lecture 44: Learn a SAS Macro function using SAS SQL

Lecture 45: Learn how to use symput() and Macro %sysevalf() functions

Lecture 46: Methods to remove duplicates from SAS data sets

Lecture 47: Learn group by, having statements and aggregation functions in SAS SQL

Lecture 48: Learn sub query used in where statement in PROC SQL

Lecture 49: Learn SQL sub query and table joining

Lecture 50: Learn PROC SQL from a complex example

Lecture 51: Learn how to union data sets using SAS SQL (1)

Lecture 52: Learn how to union data sets using SAS SQL (2)

Lecture 53: Learn how to union data sets using SAS SQL (3)

Lecture 54: Learn how to intersect data sets using SAS SQL (1)

Lecture 55: Learn how to intersect data sets using SAS SQL (2)

Lecture 56: Learn filename statement

Lecture 57: Learn methods to concatenates data in SAS

Lecture 58: Insert record into SAS data set

Lecture 59: Modify data sets using PROC SQL

Lecture 60: Learn how to pass and resolve string-like Macro variables

Lecture 61: Create tables using SQL and left join using PROC SQL

Lecture 62: Using symput function to send data step variable into Macro variable

Lecture 63: Explain a Macro function

Lecture 64: Write a SAS macro program to print the contents of three data sets

Lecture 65: Write a SAS macro function to keep specific variables in a data set

Lecture 66: Learn a SAS macro function to print the contents of three data sets

Lecture 67: Learn how to use SAS automatic Macro variable in Macro function

Lecture 68: How to find SAS version and components list

Lecture 69: Execute Macro program by sending masked parameters

Lecture 70: Passing where statement into SQL by SAS Macro

Lecture 71: Learn how to use PROC SQL options correctly

Lecture 72: Learn how to return record number using SAS SQL

Lecture 73: Understand the function of the key word 'validate' in SQL

Lecture 74: Learn special SAS library

Lecture 75: Understand index name and usages in data steps

Lecture 76: Remove tables from library using SAS SQL

Lecture 77: Display the data structure of a SAS data set in a library

Lecture 78: Save the value of a variable at specific record into a macro variable

Lecture 79: Learn how to use the STRIP function in SAS

Lecture 80: Learn how to use the STRIP function in SAS (Cont.)

Lecture 81: Create indexes on a SAS data set for efficient processing

Lecture 82: Learn cross joining tables in SAS SQL

Lecture 83: Learn how to create non-duplicated pair observations using SAS SQL

Lecture 84: Using SAS Macro program and SQL to generate various table merging

Lecture 85: Learn how to calculate summary statistics using SAS SQL

Lecture 86: Learn how to calculate summary statistics using SAS SQL (Cont.)

Lecture 87: Learn how to calculate summary statistics using SAS SQL (Cont.)

Lecture 88: Understand SQL Syntax in SAS PROC SQL

Lecture 89: Generate automatic report using PROC SQL

Lecture 90: Set bufno to use the most amount of memory resources for output buffers

Lecture 91: Use proc sql options to eliminate identical observations

Lecture 92: Use Macro function to create a data set by keeping numeric variables

Lecture 93: Create a new data set by calculating average amount for each item group

Lecture 94: Explain a type PROC SQL example with calculated expression

Lecture 95: Use PROC SQL to return the successive integers (1,2,3,…) in data set