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 (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.
