Section 1 : Course Overview, Software (SAS University Edition) set up & Course materials

Lecture 1 Course Overview 3:33
Lecture 2 File pathdirectory in SAS studio 4:25

Section 2 : An Introduction to SAS

Lecture 3 SAS Introduction 5:53

Section 3 : Get Data into SAS create temporary & permanent SAS data

Lecture 4 Read data delimited by blanks ( 8:15
Lecture 5 Read data delimited by commas (
Lecture 6 Read data delimited by any delimiters using list input 8:51
Lecture 7 Read data in fixed columns using column input 5:59
Lecture 8 Read data using formatted input including using SAS informat to read dates 8:29
Lecture 9 Read data using formatted input use SAS format to display SAS date values 8:38
Lecture 10 Create internal SAS data using DATALINES statement 3:0
Lecture 11 LIBNAME statement assign library names and create permanent SAS data sets 10:47
Lecture 12 Proc Import Import Excel data file into SAS 17:39
Lecture 13 Coding Exercise 1 Text
Lecture 14 Coding Exercise 1 Solution Text
Lecture 15 Coding Exercise 2 Text
Lecture 16 Coding Exercise 2 Solution Text

Section 4 : Work with data

Lecture 17 Use ASSIGNMENT statements in DATA step & use SET statement to create a SAS data 6:59
Lecture 18 SAS functions overview 10:25
Lecture 19 Conditionally execute SAS statements IF-THENELSE, DO and END statements
Lecture 20 Conditionally execute SAS statements IF-THENELSE, DO and END statement (Cont 13:59
Lecture 21 Subset your Data using subsetting IF statement and DELETE statement 8:35
Lecture 22 Creating One-Dimensional Arrays 14:44
Lecture 23 Coding Exercise Text
Lecture 24 Coding Exercise Solution Text

Section 5 : Creating labels and formats

Lecture 25 Use LABEL statement to add Labels to Variables in a DATA step 7:39
Lecture 26 Use FORMAT statement to assign Formats to Variables SAS Built-in Formats 13:12
Lecture 27 Create your User-Defined FORMATS 12:52
Lecture 28 Storing and Referencingusing your User-Defined FORMATS 15:52
Lecture 29 Define the length of a variable using the LENGTH statement 7:46
Lecture 30 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 31 Coding Exercise 1 Text
Lecture 32 Coding Exercise 1 Solution Text
Lecture 33 Coding Exercise 2 Text
Lecture 34 Coding Exercise 2 Solution Text

Section 6 : Use SAS Functions to manipulate character and numeric data values

Lecture 35 Convert Character & Numeric Value Auto convert, explicitly PUT & INPUT function 17:38
Lecture 36 SCAN function Separate a character value and obtain a specified wordstring 7:11
Lecture 37 SUBSTR function Extract and replace a portion of a character value 10:0
Lecture 38 TRIM and CATX functions Concatenate character values
Lecture 39 INDEX function Search a character value for a specified string 9:24
Lecture 40 UPCASE, LOWCASE and PROPCASE functions Change the case of characters 5:53
Lecture 41 TRANWRD function Replaceremove characters within a character string 6:22
Lecture 42 INT and ROUND functions Modifying Numeric Values 6:27
Lecture 43 Coding Exercise Text
Lecture 44 Coding Exercise Solution Text

Section 7 : Use SAS Functions to manipulate SAS date values

Lecture 45 Explanation on how SAS stores date and time values; Usage of MDY function 11:16
Lecture 46 YEAR, QTR, MONTH, DAY, WEEKDAY Functions Extract yearquartermonthday values 11:52
Lecture 47 TODAY, DATE, INTCK functions get current date value & number of time interval 7:52
Lecture 48 DATDIF, YRDIF function Calculate difference in days and years between two dates 11:28
Lecture 49 Coding Exercise Text
Lecture 50 Coding Exercise Solution Text

Section 8 : Process data using DO LOOPS

Lecture 51 Constructing DO loops part 1 9:54
Lecture 52 Constructing DO loops part 2 9:33
Lecture 53 Conditionally Executing DO Loops using DO UNTIL and DO WHILE 6:50
Lecture 54 Using Conditional Clauses with the Iterative DO Statement 6:30
Lecture 55 Coding Exercise Text
Lecture 56 Coding Exercise Solution Text

Section 9 : More on ARRAYS

Lecture 57 Creating Variables in an ARRAY Statement 7:32
Lecture 58 Assigning Initial Values to Arrays & Creating Temporary Array Elements 13:22
Lecture 59 Two dimensional array 8:39
Lecture 60 Coding Exercise 1 Text
Lecture 61 Coding Exercise 1 Solution Text
Lecture 62 Coding Exercise 2 Text
Lecture 63 Coding Exercise 2 Solution Text

Section 10 : Combine SAS data sets

Lecture 64 One-to-One Merging 8:27
Lecture 65 Concatenating 8:59
Lecture 66 Appending 10:45
Lecture 67 Interleaving 11:49
Lecture 68 Match merging 17:56
Lecture 69 Types of match-merging merge data sets one-to-one and one-to-many 14:3
Lecture 70 Match Merging Renaming Variables 13:3
Lecture 71 Match Merging Excluding Unmatched Observations 14:3
Lecture 72 Match Merging Selecting Variables 8:47
Lecture 73 Coding Exercise Text
Lecture 74 Coding Exercise Solution Text

Section 11 : ReconstructReshape SAS Data sets in DATA step and using Proc TRANSPOSE

Lecture 75 Convert One Obs Subject to Several Obs Subject Using a Data step 11:11
Lecture 76 Convert Several Obs Subject to One Obs Subject Using a DATA Step 13:46
Lecture 77 Convert One Obs Subject to Several Obs Subject Using PROC TRANSPOSE 16:3
Lecture 78 Convert Several Obs Subject to One Obs Subject Using PROC TRANSPOSE 8:59
Lecture 79 Coding Exercise Text
Lecture 80 Coding Exercise Solution Text

Section 12 : SAS Stat Procedures Proc SORT, PRINT, MEANS, FREQ, UNIVARIATE, Contents, Export

Lecture 81 Sorting SAS Data with PROC SORT 13:14
Lecture 82 Generate list reports with Proc PRINT VAR, SUM, WHERE, ID and BY statements 10:3
Lecture 83 Generate reports with Proc PRINT VAR, SUM, WHERE, ID and BY statements (Cont 11:51
Lecture 84 Calculate summary statistics and multilevel summaries using Proc MEANS procedure
Lecture 85 Produce one-way and two-way frequency tables with the Proc FREQ procedure- 8:37
Lecture 86 Proc Univariate More powerful way to Describing and Summarizing data 8:15
Lecture 87 Proc Content investigateview the Contents of a SAS Libraries or a SAS data set 6:7
Lecture 88 Proc Export Export data to create standard, comma-delimited, Excel data files 10:0
Lecture 89 Coding Exercise Text
Lecture 90 Coding Exercise Solution Text

Section 13 : Generate reports using ODS statements

Lecture 91 ODS overview with examples creating PDF, RTF, PowerPoint outputs 13:27
Lecture 92 ODS Creating HTML Output with Options 8:41
Lecture 93 ODS Creating Excel Output with multiple work sheets 11:0
Lecture 94 Coding Exercise Text
Lecture 95 Coding Exercise Solution Text

Section 14 : Error Handling identify and resolve SAS errors

Lecture 96 Syntax errors misspelled keywords, unmatched ' ', missing ; , invalid option 13:46
Lecture 97 Logic Error PUTLOG statement, ERROR statement, temporary variables N and ERROR 15:23
Lecture 98 Coding Exercise Text
Lecture 99 Coding Exercise Solution Text

Section 15 : SAS Macro Essentials

Lecture 100 SAS Macro Overview 2:48
Lecture 101 Replacing Text Strings Using Macro Variables 5:56
Lecture 102 Generating SAS Code Using Macros 6:4
Lecture 103 Passing Information into a Macro Using Parameters 4:29
Lecture 104 Coding Exercise Text
Lecture 105 Coding Exercise solution Text

Section 16 : Proc SQL Essentials

Lecture 106 Retrieve Data from a Single Table using the Select Statement 10:26
Lecture 107 Retrieve Data from Multiple Tables using Inner Join 18:6
Lecture 108 Retrieve Data from Multiple Tables using Outer Joins 10:43
Lecture 109 Coding Exercise Text
Lecture 110 Coding Exercise Solution Text

Section 17 : Hands-on Project Case study on Weight Loss data

Lecture 111 Project step-by-step instruction & Excel data file 2:38
Lecture 112 Project Solution Video
Lecture 113 Project SAS Code Downloadable Text

Section 18 : Installed SAS University Edition WIll End Aug 2, 2021

Lecture 114 Install SAS University Edition (SAS studio) the complete and step-by-step guide 14:58
Lecture 115 Virtual box 6 11:39
Lecture 116 How to use SAS onDemand academics if you can NOT install SAS University Edition 11:53
Lecture 117 Downloadable course materials SAS programs and Data used in the course, + PPTs 0:57