Course Outline
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.
- Utilizing 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.
Statistical 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
Requirements
- Familiarity with navigating folder structures.
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
lots of pratical exercises
