Course Overview and Supplements
A Introduction to SAS
Getting Data into SAS
-
Read data delimited by blanks using list input (7:40)
-
Read data delimited by commas using list input (4:22)
-
Read data delimited by any delimiters using list input (8:18)
-
Read data in fixed columns using column input (5:49)
-
Read data in fixed columns using formatted input: Part 1 (8:05)
-
Read data in fixed columns using formatted input: Part 2 (7:55)
-
Create internal SAS data using DATALINES statement (2:52)
-
Create permanent SAS datasets using LIBNAME statement (10:02)
-
Import Excel file into SAS using Proc Import (15:29)
-
Proc Import: Import external delimited data files into SAS
-
Quiz
-
Coding Exercise 1
-
Coding Exercise 1: Solution
Working with Data
-
Create and redefine variables using assignment statements (6:52)
-
Use SAS functions (9:46)
-
Perform conditional processing using IF-THEN statements (12:26)
-
Group observations with IF-THEN/ELSE Statements (13:52)
-
Subset your Data (8:02)
-
Simplify your data with Array: one dimensional (13:53)
-
continue on Array: two dimensional (7:38)
-
Quiz
-
Coding Exercise 2
-
Coding Exercise 2: Solution
Sorting, Summarizing data using SAS Procedures
-
Sorting Your Data with PROC SORT (11:48)
-
Generate list reports with Proc PRINT: VAR, SUM, WHERE, ID and BY statements (8:29)
-
Generate reports with Proc PRINT: VAR, SUM, WHERE, ID and BY statements (Cont.) (10:07)
-
Summarizing Your Data Using PROC MEANS (10:50)
-
Counting Your Data with PROC FREQ (7:47)
-
Proc Univariate: More powerful way to Describing and Summarizing data (7:28)
-
Proc Export: Export data to create standard, comma-delimited, Excel data files (9:23)
-
Proc Content: investigate/view the Contents of a SAS Libraries or a SAS data set (5:50)
-
Quiz
-
Coding Exercise 3
-
Coding Exercise 3: Solution
SAS Macro Introduction
Error Handling: identify and resolve SAS errors
Generate reports using ODS statements
