SAS Fundamentals Course Outline
(3 days)
Overview
This course will provide you with the required experience in programming and data management using SAS to be able to import and export raw data files, manipulate and transform data, combine SAS data sets, create basic detail and summary reports using SAS procedures, and identify and correct data, syntax and programming logic errors.
Who this class is for
It is for data scientists and analytics.
Special Note to New Hampshire Residents
This course has not yet been approved by the State's Department of Education. Please contact us to get an update as to when the class should be available in New Hampshire
Prerequisites
No prior knowledge of SAS is required.
Course Outline
Getting Started
Installation
What is SAS?
Tour
Libraries
Reports
Graphs
Bar chart
How to sort a bar chart?
Snippets
Tasks
Main components of SAS program
Data Step
Proc Step
Getting Data Into SAS
Enter DATA in program code
freeform list input
compact method
column input
formatted input
multiple-line data
Libraries
Accessing your existing local files
INFILE technique
Libraries
Accessing Data in SAS Libraries
Create a new Library
Add new table to the library
Preparing Data for Analysis
label variables with explanatory names
create new variables
use SAS® IF-THEN-ELSE statements
use DROP and KEEP to select variables
use the SET statement
use PROC SORT
append and merge data sets
use PROC FORMAT
Going Deeper: find first and last values in a group
Graphs
Scatter Plot
Histogram
Series Plot
Statistical Analyses and Linear Models
Statistical Analyses
One-Way Frequency
Summary Statistics
Correlation Analysis
One-Sample t Tests
Paired-sample t test
Two-Sample t Tests
Linear Models
One-Way ANOVA
N-Way ANOVA
Advanced Programming Topics Part I
use SAS® Functions
TRANSPOSE data sets
perform data recoding using SELECf
use SAS programming techniques to clean up a messy data set
Advanced Programming Topics Part 2
create and use arrays
use DO loops
use the RETAIN statement
create and use SAS® macro variables
create and use SAS macro routines
Data Science in action
Data Science Process
Research points
Big Data in Healthcare Applications
Digital Hospital
Predicting Workflow
Emergency Department Demo
Presidential Elections
Population
Voters’ Data
History
Groups: Gender-Age-Race
Voter Turnout
Issues
Factors affecting Maine Economy
Exit Polls
Modeling
Visualization
Kaggle
SAS Certification
Regression
use SAS procedures to perform simple linear regression
use SAS procedures to perform multiple linear regression
use SAS procedures to calculate predictions using a model
use SAS procedures to perform residual analysis
Project/Case Study
We’ll work on real data set to practice by hand everything learnt throughout the course
Clean the data column by column
Do Correlation between the outcome and the variables
Analyze the results and write a report explaining the numbers
View outline in Word
XSAS01
Facebook
LinkedIn