Introduction
SAS in Depth
- SAS data sets
- SAS variables
- SAS libraries
- SAS code structure
Preparing the Development Environment
- Installing and configuring SAS Studio
- Installing and configuring WPS
Data management in SAS
- Importing data
- Exporting data
- Creating variables and calculations
- Filtering observations
- Creating conditionals and loops
- Merging data sets
- Using statements
- Cleaning data
Arrays and Functions
- Recording new variables with loops
- Constructing new variables
- Using built in SAS functions
- Combining raw data files
Data Visualization
- Creating a bar chart
- Creating a scatter plot
- Creating a pie graph
- Overlaying plots
Statistics Analysis
- Reporting data
- Using linear regressions
- Using multiple regressions
- Interpreting data
- Making predictions
SAS SQL
- SAS SQL syntax
- Using clauses and statements
- Working with columns and rows
- Working with tables
SAS Index
- Testing with data sets
- Using PROC
- Creating, updating, and applying an index
SAS Macro
- Using macro variables
- Using macro functions
- Creating a Macro
- Debugging and storing Macros
Predictive Modeling
- Using linear regressions
- Using multiple regressions
- Evaluating data patterns
- Using input variables
- Working with PROC MI
Summary and Conclusion
Introduction
Core Programming and Syntax in R
- Variables
- Loops
- Conditional statements
Fundamentals of R
- What are vectors?
- Functions and packages in R
Preparing the Development Environment
- Installing and configuring R and RStudio
- Setting up Rserve
Classifying Data
- Moving data between R and Tableau
- Preparing and cleaning data
- Modeling and scripting in R
Regressions in R and Tableau
- Creating a regression model
- Visualizing regressions
- Predicting and comparing values
Clustering and Models
- Working with clustering algorithms
- Creating clusters
- Visualizing clustered data
Advanced Analytics with R and Tableau
- Using CRISP-DM
- Working with TDSP models
- Summarizing data
