SAS Programming

Course Curriculum

Chapter 1: Introduction to SAS

Lecture 1: What is SAS?

Lecture 2: Different SAS products, interface and how to use it?

Lecture 3: Concept of SAS Libraries

Lecture 4: Different steps in SAS commands

Lecture 5: Creating temporary and permanent SAS datasets

Lecture 6: Metadata structures of a SAS dataset

Lecture 7: Using Rename and Label for variables in a dataset

Chapter 2: The Procedure step in SAS

Lecture 1: Generating list of reports using print procedure

Lecture 2: Print procedure for specific variables

Lecture 3: Supressing the OBS number and setting an ID variable

Lecture 4: Using custom labels in Print procedure

Lecture 5: Using keywords like Sum and N with print procedure

Lecture 6: Generating reports using proc contents

Lecture 7: Using Proc contents for multiple data

Lecture 8: Using additional keywords with proc contents

Chapter 3: Subsetting in SAS

Lecture 1: Creating subsets of a data using FIRST OBS and OBS technique

Lecture 2: Using keep and drop in SAS data step

Lecture 3: Introduction to basic where clause in SAS

Lecture 4: Patterns matching using where clause

Lecture 5: Wildcard matching and more using where clause

Lecture 6: If, then, else in SAS

Lecture 7: Select, when, otherwise in SAS

Lecture 8: Splitting of data sets in SAS

Chapter 4: Sorting and finding the unique values in SAS

Lecture 1: Sorting datasets using Proc sort

Lecture 2: Sorting existing data Vs. Creating a new sorted data

Lecture 3: Finding unique values using Nodup

Lecture 4: Finding unique values using Nodupkey

Chapter 5: Table creation in SAS

Lecture 1: Frequency distribution table in SAS

Lecture 2: Cross-tabulation in SAS

Lecture 3: Using additional keywords with cross-table

Lecture 4: Understanding the basics of Proc Tabulate technique

Lecture 5: More applications using Proc Tabulate

Chapter 6: Descriptive statistics in SAS

Lecture 1: What is descriptive statistics and what are the techniques available in SAS?

Lecture 2: Understanding Proc Summary technique in SAS

Lecture 3: Understanding Proc Means technique in SAS

Lecture 4: Understanding Proc Univariate technique in SAS

Chapter 7: Exporting and Importing datafiles in SAS

Lecture 1: Exporting SAS data file to CSV file

Lecture 2: Exporting SAS data file to Text file formats

Lecture 3: Exporting SAS data file to Excel file formats

Lecture 4: Importing CSV to SAS data file

Lecture 5: Importing Text file formats to SAS data file

Lecture 6: Importing Excel file formats to SAS data file

Chapter 8: Formats and Functions in SAS

Lecture 1: Creating user defined character formats in SAS

Lecture 2: Creating user defined numeric formats in SAS

Lecture 3: Data functions in SAS

Lecture 4: Calculating date difference in SAS

Lecture 5: Standard text functions in SAS

Lecture 6: More on text functions and matching strings

Lecture 7: Standard numeric functions in SAS

Chapter 9: Appending and Merging of data sets in SAS

Lecture 1: Transposing existing data set in SAS

Lecture 2: Appending of datasets in SAS

Lecture 3: Appending keeping common variables

Lecture 4: Merging of datasets in SAS

Lecture 5: Left, Right, Inner and Outer Merging of data in SAS

Lecture 6: One to many merging of data in SAS

Lecture 7: Many to many merging of data in SAS

Chapter 10: Arrays and reading raw files in SAS

Lecture 1: Using Arrays for calculation part 1

Lecture 2: Using Arrays for calculation part 2

Lecture 3: Importing raw data in SAS

Lecture 4: Importing raw delimited data with missing values in SAS

Chapter 11: Structured Query Language (SQL) in SAS using Proc SQL

Lecture 1: Introduction to SQL in SAS

Lecture 2: Using Proc SQL to select columns and display reports

Lecture 3: Labeling columns in Proc SQL

Lecture 4: Assigning formats to columns

Lecture 5: Sorting datasets using Proc SQL

Lecture 6: Ordering by unselected columns and column references

Lecture 7: Finding unique observations using Proc SQL

Lecture 8: Creating new calculated columns using Proc SQL

Lecture 9: Creating new columns using conditional statements

Lecture 10: Using where clause in Proc SQL

Lecture 11: Missing value treatment using Proc SQL

Lecture 12: Grouping observations using Proc SQL

Lecture 13: Simple summarization using Proc SQL

Lecture 14: Conditional summarization using Proc SQL

Lecture 15: Multiple subquery

Chapter 12: Data Manipulation and Joining using Proc SQL

Lecture 1: Using Union, Intersect and Except clause in Proc SQL

Lecture 2: Storing the results in a new data set using Proc SQL

Lecture 3: Inserting new observations in an existing data using Proc SQL

Lecture 4: Updating and deleting observations using Proc SQL

Lecture 5: Creating a new dataset from scratch using Proc SQL

Lecture 6: Dropping and Adding columns in a data using Proc SQL

Lecture 7: Joining datasets using full join method in Proc SQL

Lecture 8: Joining datasets using Inner join method in Proc SQL

Lecture 9: Joining datasets using Left join method in Proc SQL

Lecture 10: Joining datasets using Right join method in Proc SQL

Chapter 13: SAS Macros

Lecture 1: Understanding SAS Macro and why it is used?

Lecture 2: Creating a basic macro program