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 (3)
Abhi has excellent knowledge of Alteryx and he explained things very clearly. He understood our goals and created bespoke demo datasets that were relevant to our organisation, which was very impressive. The training was well-structured and delivered at a good pace, with time for questions.
Samuel Taylor - Manchester Metropolitan University
Course - Alteryx for Data Analysis
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
Clear explanations with good examples so i could relate to my own line of work.
