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
Managing Data in SAS
- Importing data
- Exporting data
- Variable creation and calculations
- Filtering observations
- Implementing conditionals and loops
- Merging data sets
- Utilizing statements
- Data cleaning techniques
Arrays and Functions
- Creating new variables using loops
- Constructing new variables
- Applying built-in SAS functions
- Combining raw data files
Data Visualization
- Generating bar charts
- Creating scatter plots
- Developing pie graphs
- Overlaying multiple plots
Statistical Analysis
- Reporting on data
- Applying linear regression
- Using multiple regression
- Interpreting analytical results
- Generating predictions
SAS SQL
- Understanding SAS SQL syntax
- Utilizing clauses and statements
- Manipulating columns and rows
- Managing tables
SAS Indexing
- Testing with data sets
- Using PROC
- Creating, updating, and applying indexes
SAS Macros
- Working with macro variables
- Utilizing macro functions
- Creating Macros
- Debugging and storing Macros
Predictive Modeling
- Applying linear regression
- Using multiple regression
- Assessing data patterns
- Utilizing input variables
- Working with PROC MI
Summary and Conclusion
Requirements
- Familiarity with navigating folder structures
Target Audience
- Data Analysts
Testimonials (3)
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