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
- 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
Requirements
- Experience with navigating folder structures
Audience
- Data Analysts
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (5)
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
the ease of explanation and the professor's robust knowledge
JOSE FERNANDO MELO - MCGRAW-HILL INTERAMERICANA
Course - Alteryx Advanced
Machine Translated
The practical exercises, the course order, and the explanations were clear
Cristina Morales - SOFI de Chihuahua SA de CV
Course - Alteryx for Data Analysis
Machine Translated
Very clearly articulated and explained
Harshit Arora - PwC South East Asia Consulting
Course - Alteryx for Developers
Linear regression - the algorithm to predict the trend