Course Outline
Introduction
SAS in Depth
- Understanding SAS data sets
- Working with SAS variables
- Managing SAS libraries
- Understanding SAS code structure
Setting Up the Development Environment
- Installing and configuring SAS Studio
- Installing and configuring WPS
Data Management in SAS
- Importing data into SAS
- Exporting data from SAS
- Creating variables and performing calculations
- Filtering observations
- Implementing conditionals and loops
- Merging multiple data sets
- Utilizing essential statements
- Cleaning and preparing data
Arrays and Functions
- Generating new variables using loops
- Constructing new variables
- Applying built-in SAS functions
- Combining raw data files
Data Visualization
- Creating bar charts
- Creating scatter plots
- Creating pie graphs
- Overlaying multiple plots
Statistical Analysis
- Generating data reports
- Applying linear regression
- Applying multiple regression
- Interpreting statistical data
- Making predictive estimates
SAS SQL
- Understanding SAS SQL syntax
- Utilizing clauses and statements
- Manipulating columns and rows
- Working with database tables
SAS Index
- Testing with data sets
- Using PROC procedures
- Creating, updating, and applying indexes
SAS Macro
- Utilizing macro variables
- Utilizing macro functions
- Developing Macros
- 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
Requirements
- Familiarity with navigating file and folder structures
Target Audience
- Data Analysts
Testimonials (4)
Deepthi was super attuned to my needs, she could tell when to add layers of complexity and when to hold back and take a more structured approach. Deepthi truly worked at my pace and ensured I was able to use the new functions /tools myself by first showing then letting me recreate the items myself which really helped embed the training. I could not be happier with the results of this training and with the level of expertise of Deepthi!
Deepthi - Invest Northern Ireland
Course - IBM Cognos Analytics
he was well prepared - and he is very sympathetic
Oliver - Post CH AG
Course - Splunk Fundamentals
Used good examples, good pace of the training and covered most things
David - McGraw Hill
Course - Data Preparation with Alteryx
Clear explanations with good examples so i could relate to my own line of work.
