What will i learn?
Curriculum for this course
126 Lessons
00:00:00 Hours
SAS Overview
6 Lessons
00:00:00 Hours
- SAS Overview 00:00:00
- SAS Environments 00:00:00
- Obtaining and installing a SAS environment 00:00:00
- SAS Interfaces 00:00:00
- Introducing SAS Programs 00:00:00
- Submitting a Program 00:00:00
SAS Studio
8 Lessons
00:00:00 Hours
- SAS Studio interface Elements 00:00:00
- SAS Studio navigation pane 00:00:00
- SAS Studio code tab 00:00:00
- SAS Studio log tab 00:00:00
- SAS Studio autocomplete 00:00:00
- SAS Studio results tab 00:00:00
- SAS Studio tasks 00:00:00
- SAS Studio libraries 00:00:00
Practice: SAS Basics
1 Lessons
00:00:00 Hours
- Practice 00:00:00
SAS Overview - Test
1 Lessons
00:00:00 Hours
- SAS Overview - Test
SAS Data Sets
6 Lessons
00:00:00 Hours
- Data Set Descriptors 00:00:00
- Printing a Data Set 00:00:00
- Data Library 00:00:00
- Using Data Libraries 00:00:00
- Assigning a Libref to a Relational Database 00:00:00
- Connecting to a Relational Database Source 00:00:00
Reading Data Sets
7 Lessons
00:00:00 Hours
- SAS Data Sources 00:00:00
- Using the DATA Statement to Create a Data Step 00:00:00
- Using the SET Statement for Data Step Processing 00:00:00
- Using the WHERE Statement to Subset Observations 00:00:00
- Using the DROP and KEEP Statements 00:00:00
- Adding Labels Using the LABEL Statement 00:00:00
- Adding Formats Using the FORMAT Statement 00:00:00
Reading from Excel
6 Lessons
00:00:00 Hours
- Creating a Data Set from an Excel Sheet 00:00:00
- Reading from an Excel Sheet 00:00:00
- Using the PROC Step to Create an Excel Sheet 00:00:00
- Using the ODS to Create an Excel Sheet 00:00:00
- Using the IMPORT Wizard with Excel 00:00:00
- Using the EXPORT Wizard with Excel 00:00:00
Reading Text Files
6 Lessons
00:00:00 Hours
- Creating a Data Set from a Delimited File 00:00:00
- Using the LENGTH Statement 00:00:00
- Reading Nonstandard Data with Informats 00:00:00
- Processing Nonstandard Data in the DATA Step 00:00:00
- Using the List Input DSD Option 00:00:00
- Using the MISSOVER Option 00:00:00
Practice: Work with Data
1 Lessons
00:00:00 Hours
- Practice 00:00:00
Data Errors
4 Lessons
00:00:00 Hours
- Data Errors in Raw Data 00:00:00
- Validating and Cleaning Data 00:00:00
- Examining Data Errors 00:00:00
- Handling Data Errors 00:00:00
Data Validation and Cleaning
7 Lessons
00:00:00 Hours
- Validating Data Using PRINT and WHERE 00:00:00
- Validating Data Using FREQ and TABLES 00:00:00
- Validating Data Using MEANS and VAR 00:00:00
- Validating Data Using UNIVARIATE and VAR 00:00:00
- Cleaning Data At the Source 00:00:00
- Cleaning Data Using Assignment Statements 00:00:00
- Cleaning Data Using Conditionals in the DATA Step 00:00:00
Data Manipulation
6 Lessons
00:00:00 Hours
- Creating Variables with DATA Step Assignments 00:00:00
- Creating Values Using Operators and SAS Functions 00:00:00
- Executing Statements Conditionally 00:00:00
- Using the ELSE Statement in a Conditional 00:00:00
- Using IF and WHERE to Subset Observations 00:00:00
- Using IF-THEN DELETE to Subset Observations 00:00:00
Combining Data Sets
7 Lessons
00:00:00 Hours
- Combining SAS Data Sets 00:00:00
- Using APPEND to Combine Data Sets 00:00:00
- Using the FORCE Option to an APPEND Procedure 00:00:00
- Using SET in a DATA Step to Concatenate Data Sets 00:00:00
- Merging Data Sets One-To-One 00:00:00
- Merging Data Sets One-To-Many 00:00:00
- Merging Data Sets with Nonmatches 00:00:00
Practice: Validate, Clean, and Combine Data
1 Lessons
00:00:00 Hours
- Validate, Clean, and Combine Data 00:00:00
Reports
7 Lessons
00:00:00 Hours
- Producing a Basic Report 00:00:00
- Using the LABEL Statement to Add Column Headings 00:00:00
- Formatting Values Using the FORMAT Statement 00:00:00
- Creating and Applying User-defined Formats 00:00:00
- Subsetting and Grouping Reports Using WHERE and BY 00:00:00
- Directing Output Using ODS Statements 00:00:00
- Specifying Styles in an ODS Statement 00:00:00
Summary Reports
7 Lessons
00:00:00 Hours
- Creating Frequency Tables with the FREQ Procedure 00:00:00
- Creating Enhanced Frequency Tables 00:00:00
- Creating Summary Tables with the MEANS Procedure 00:00:00
- Creating Summary Tables with the SUMMARY Procedure 00:00:00
- Creating Enhanced Summary Tables 00:00:00
- Creating Tabular Reports with the TABULATE Procedure 00:00:00
- Creating Output Data Sets Using the OUT Option 00:00:00
Graphics
2 Lessons
00:00:00 Hours
- Overview of SAS_GRAPH SG Procedures 00:00:00
- Creating Pie Charts with SAS_GRAPH SG Procedures 00:00:00
Practice: Reports and Charts
1 Lessons
00:00:00 Hours
- Practice 00:00:00
Input and Output
4 Lessons
00:00:00 Hours
- Outputting Multiple Observations 00:00:00
- Writing to Multiple SAS Data Sets 00:00:00
- Controlling Variable Input and Output 00:00:00
- Controlling Observation Input and Output 00:00:00
Data Summarization
4 Lessons
00:00:00 Hours
- Creating an Accumulating Variable Using RETAIN 00:00:00
- Creating an Accumulating Variable Using SUM 00:00:00
- Summarizing Data by Groups 00:00:00
- Summarizing Data by Multiple Groups 00:00:00
Read Raw Data
5 Lessons
00:00:00 Hours
- Using Column Input 00:00:00
- Using Formatted Input 00:00:00
- Creating a Single Observation from Multiple Records 00:00:00
- Controlling When a Record Loads 00:00:00
- Reading Raw Data with Missing Values 00:00:00
Data Transformation
5 Lessons
00:00:00 Hours
- Using SAS Functions 00:00:00
- Separating and Concatenating Character Values 00:00:00
- Using Descriptive Statistics Functions 00:00:00
- Truncating Numeric Values 00:00:00
- Converting Values Between Data Types 00:00:00
Debugging
2 Lessons
00:00:00 Hours
- Debugging with PUTLOG 00:00:00
- Debugging Logic Errors 00:00:00
Practice: Data Manipulation
1 Lessons
00:00:00 Hours
- Practice 00:00:00
Iterative DO Loops
5 Lessons
00:00:00 Hours
- Creating a Simple DO Loop 00:00:00
- DO WHILE Loops 00:00:00
- DO UNTIL Loops 00:00:00
- Nesting DO Loops 00:00:00
- Using a DO Loop to Reduce Redundant Code 00:00:00
SAS Arrays
5 Lessons
00:00:00 Hours
- SAS Array Overview 00:00:00
- Creating a SAS Array 00:00:00
- Processing a SAS Array 00:00:00
- Using SAS Arrays to Create Variables 00:00:00
- Using SAS Arrays to Perform Calculations 00:00:00
Restructuring and Combining Data Sets
7 Lessons
00:00:00 Hours
- Using the TRANSPOSE Procedure to Manipulate Data 00:00:00
- Rotating a Data Set with the TRANSPOSE 00:00:00
- Match-Merging SAS Data Sets 00:00:00
- Match Merging Data Sets that Lack a Common Variable 00:00:00
- Match Merging a SAS Data Set and an Excel Workbook 00:00:00
- Manipulations with a Match-Merge 00:00:00
- Match Merging Data Sets with Same-named Variables 00:00:00
Proc SQL
3 Lessons
00:00:00 Hours
- ProSQL overview 00:00:00
- Querying with Proc SQL 00:00:00
- Joining Tables with Proc SQL 00:00:00
Practice: Array Processing & Merges
1 Lessons
00:00:00 Hours
- Practice 00:00:00
Requirements
+ View more
Description
+ View more
Other related courses
About the instructor
- 0 Reviews
- 785 Students
- 152 Courses
Student feedback
Reviews
Write a public review