SAS Training by Reviewing and Solving Certificate Questions

Course Curriculum

Chapter 1: Course introduction

Lecture 1: Course introduction: content, resources and approah

Lecture 2: SAS installation, version and environment

Chapter 2: Walk through each question by reviewing SAS

Lecture 1: Teaching approach (with PDF downloadable)

Lecture 2: Know SAS library and current folder

Lecture 3: Learn data type, missing values in SAS data sets

Lecture 4: Learn set statement, _n_ and logical operators in SAS

Lecture 5: Know if statement to restrict or subset SAS data sets

Lecture 6: Understand output statement, do loop structure

Lecture 7: Know page number setting for SAS procedure output

Lecture 8: Learn SAS format to display data as you want

Lecture 9: How to input data from data step using position input

Lecture 10: Learn data input using DSD, how to input missing values

Lecture 11: How to use filename statement in SAS for data input and output

Lecture 12: Rename methods and how it affects other operations

Lecture 13: About date type, data conversion, functions and informat

Lecture 14: Understand data line holding, strongly holding and training sign @

Lecture 15: Understand holding, strong holding and trailing

Lecture 16: Learn in operator, if then statement

Lecture 17: Learn output statement, merge statement

Lecture 18: Understand set statement, (in=) and if statement

Lecture 19: Test sort and merge data sets in SAS

Lecture 20: Learn relational merging data sets

Lecture 21: Learn sorting data, nodupkey option

Lecture 22: Understand ranuni() function and random sampling

Lecture 23: Learn usages of set statement in setting multiple data stes

Lecture 24: Setting multiple data sets in one data step

Lecture 25: Learn date type data and operations

Lecture 26: Learn date format and date operations

Lecture 27: Concatenate string, date type, input() and put() functions

Lecture 28: Compbl() function, do loop and output statement

Lecture 29: Test date function — weekday()

Lecture 30: Understand how to use informat in reading date and missing values

Lecture 31: Know how to save observations into external files

Lecture 32: data _null_, put statement, infile statement and DSD option

Lecture 33: Test variable expression, logical expression

Lecture 34: About usages of the keep statements

Lecture 35: Learn the output about proc contents

Lecture 36: Learn statements and options in proc datasets

Lecture 37: Understand functionality of proc flist

Lecture 38: Delete data in the library

Lecture 39: Understand array and data transformation

Lecture 40: Learn SAS array and its relationship with variables

Lecture 41: Extract variables with a specified data type using array

Lecture 42: Learn how to transform data set using data step

Lecture 43: Use array and summarized function in data step

Lecture 44: Understand usage of SAS array in data step

Lecture 45: About proc sort and its nodupkey option

Lecture 46: Know how to use data step to get cumulative data

Lecture 47: Knowledge about do loop, output and return statements

Lecture 48: Know how to use _error_ and error handling method in SAS

Lecture 49: Understand merging data sets by consistent order

Lecture 50: Learn round() function in data step

Lecture 51: Understand missing value and logical operation

Lecture 52: How to use lag and dif function in SAS

Lecture 53: Understand date format and relationship with string

Lecture 54: Test how to use proc format to create format used in data step

Lecture 55: Learn how to create format based on numerical range

Lecture 56: Test your understanding about proc means

Lecture 57: Understand by and class statements in proc means

Lecture 58: About debug option and usage in data step

Lecture 59: Data conversion: substr(), input() and put() functions

Lecture 60: Understand the concept about SAS macro _error_

Lecture 61: Define valid library

Lecture 62: Read data based on position, informat and modifier

Lecture 63: Understand firstobs, obs options in SAS data step and procedures

Lecture 64: Understand firstobs and obs options (2)

Lecture 65: Read raw data into SAS table from external files

Lecture 66: Test output, _n_ and if..else statements in one data step

Lecture 67: Know SAS format definition and location

Lecture 68: Test how to use do while and break condition

Lecture 69: Understand how to use label statement in data step

Lecture 70: Know how to apply cat() and catx() functions

Lecture 71: Learn string function: finding positions in a string

Lecture 72: Learn how to split data based on coditions

Lecture 73: Use array and create missing values

Lecture 74: Use array and create missing values (2)

Lecture 75: Use array to create variables in data step

Lecture 76: Understand logical conditions in if statements

Lecture 77: Learn how to apply multiple filters based on several if statements

Lecture 78: Understand date, character types in data step

Lecture 79: Learn how to apply universal string matching to query data

Lecture 80: Apply proc means to create descriptive statistics and output

Lecture 81: Apply proc means to create descriptive statistics and output (2)

Lecture 82: Apply proc freq and obtain the intended output

Lecture 83: Create two ways frequency cross tab and intended output

Lecture 84: Understand options in proc report

Lecture 85: How to apply ODS in SAS to create intended output

Lecture 86: Getting resulting table based on if then filters

Lecture 87: Use if…else if statement

Lecture 88: Debug syntax errors in data step

Lecture 89: Understand trailing symbols used to read data

Lecture 90: Data type conversion using put() function

Lecture 91: Data tytpe conversion (2)

Lecture 92: Keep and drop variables in data step

Lecture 93: Use single trailing to conditionally read data

Lecture 94: Transpose data, create cumulative data using retain statement

Lecture 95: About data error and log

Lecture 96: Correctly use firstobs and obs option in SAS procedures