Introduction
- SAS Enterprise Guide, SAS Studio, WPS ***very important***
- How to Find, Install, and Use SAS Studio/SAS OnDemand For Academics
- How to Find, Install, Register for, Use, and Upload Data-sets with WPS
- All the Data-sets are attached to this Lecture!
- Common Problems With Install/Upload/Videos (Watch for Best Course Experience!)
Importing
- Import .txt
- Import .csv
- Import .XLSX
- Quiz for Importing
SAS Syntax, Data Step vs. Proc Step, SAS compared to R/Python
- Data Step vs. Proc Step
- SAS Syntax
- Manually Creating Data with R, Python, and SAS
Working with Data
- Data Set Options
- What if your data is separated by a dot or something else? (delimiters)
- Reading data instream in data step (typing data right into coding area)
- Reading DATES in data
- Creating Variables/Calculations
- More on Creating New Variables
- Automatic Variables
- Filtering Observations (so only some data show up)
- Intuition For If-Then/Else and Do, Do-While, Do-Until
- If-then Conditional Logic
- DO Iterative Loop and Variations (DO WHILE, DO Until)
- More on DO Group Processing (without index/counter variable)
- More on the WHERE Expression/Statement
- IF vs. WHERE
- Sorting Observations (PROC SORT and BY statements)
- Merging Two Data Sets
- Using SET statement to Merge
- Data Reduction and Cleaning your Data
- LENGTH statement
- Creating a Counting (Enumeration) Variable
- Data Section Quiz
- Assignment 0.5: Integration Assignment 0.5
Back to Importing
- Importing SPSS file with SAS language
Input Types and Informats + User-defined formats
- List Input
- Column Input
- Formatted Input And Informats
- User Defined Formats
- Informats/Formats and SAS Input Style Quiz
Arrays
- Arrays 1 (Recoding Variables)
- Arrays 2 (Constructing new variables)
SAS Functions
- Understanding SAS Functions
- RAND Function (producing a sample with distribution of your choice)
- LENGTH, LENGTHN, LENGTHC functions (are you working with a large data set?)
- TRIM function (want to get rid of trailing blanks?)
- COMPRESS Function (remove characters from string, and all types of blanks)
- Input and Put Functions
- CATX function
- SCAN function
- Help Me Understand Your Needs
- Coalesce function
- Verify function
- Substr function
- Functions Quiz
Assignments
- Integration Assignments
- Integration of Skills 1
- Integration of Skills 2
- Ratings/Reviews
Advanced Techniques - Flexibility and Efficiency
- Flexible Programming 1 - Combining multiple raw data files vertically
Visual representation of data
- Scatter Plot
- Bar Graph
Statistical Analysis
- Some information for this section
- T-test independent samples overview (example)
- Doing an Independent samples t-test analysis
- Chi-square independence overview (example)
- Doing a Chi-square (independent groups) analysis
Statistical Analysis - Part 2 (Linear and Multiple Regression)
- Refresh Your Memory - Regression Edition
- Performing the Linear Regression
- Performing Multiple Regression
Case Studies
- Important note before you start!
- Case Study (Health Care Case Study) PART 1
- Case Study (Health Care Case Study) PART 2
- Code for Case Study
- Congrats on Finishing Part 1: Data Step
SQL Fundamentals
- SQL Snytax
- WHERE Clause
- SELECT statement and Columns
- CASE Logic
- Summary Functions
- SAS SQL Assignment 1
- SAS SQL Assignment 1 Solution
SAS SQL and Joining
- How to Perform an Inner Join
- How to Join Three Tables
