Course Outline
Introduction
In-Depth Look at SAS
- SAS data sets
- SAS variables
- SAS libraries
- Structure of SAS code
Setting Up the Development Environment
- Installation and configuration of SAS Studio
- Installation and configuration of WPS
Data Management in SAS
- Importing data
- Exporting data
- Creating variables and performing calculations
- Filtering observations
- Constructing conditionals and loops
- Merging data sets
- Utilizing statements
- Data cleaning
Arrays and Functions
- Recording new variables using loops
- Building new variables
- Leveraging built-in SAS functions
- Combining raw data files
Data Visualization
- Creating bar charts
- Creating scatter plots
- Creating pie graphs
- Overlaying multiple plots
Statistical Analysis
- Data reporting
- Applying linear regression
- Applying multiple regression
- Interpreting data insights
- Generating predictions
SAS SQL
- SAS SQL syntax
- Utilizing clauses and statements
- Manipulating columns and rows
- Working with tables
SAS Indexing
- Testing with data sets
- Using PROC
- Creating, updating, and applying indexes
SAS Macros
- Utilizing macro variables
- Utilizing macro functions
- Building a Macro
- Debugging and storing Macros
Predictive Modeling
- Applying linear regression
- Applying multiple regression
- Evaluating data patterns
- Utilizing input variables
- Working with PROC MI
Summary and Conclusion
Requirements
- Familiarity with navigating folder structures
Target Audience
- Data Analysts
Testimonials (4)
Refactoring Exercise and Graph Visualization
Tiago Kocevar - Lang Energie AG / Osterwalder Zurich AG
Course - Business Intelligence and Data Analysis with Metabase
Machine Translated
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
lots of pratical exercises
