Course Outline
Introduction
SAS in Depth for Government
- SAS data sets
- SAS variables
- SAS libraries
- SAS code structure
Preparing the Development Environment for Government
- Installing and configuring SAS Studio
- Installing and configuring WPS
Data Management in SAS for Government
- Importing data
- Exporting data
- Creating variables and calculations
- Filtering observations
- Creating conditionals and loops
- Merging data sets
- Using statements
- Cleaning data
Arrays and Functions for Government
- Recording new variables with loops
- Constructing new variables
- Using built-in SAS functions
- Combining raw data files
Data Visualization for Government
- Creating a bar chart
- Creating a scatter plot
- Creating a pie graph
- Overlaying plots
Statistical Analysis for Government
- Reporting data
- Using linear regressions
- Using multiple regressions
- Interpreting data
- Making predictions
SAS SQL for Government
- SAS SQL syntax
- Using clauses and statements
- Working with columns and rows
- Working with tables
SAS Index for Government
- Testing with data sets
- Using PROC
- Creating, updating, and applying an index
SAS Macro for Government
- Using macro variables
- Using macro functions
- Creating a Macro
- Debugging and storing Macros
Predictive Modeling for Government
- Using linear regressions
- Using multiple regressions
- Evaluating data patterns
- Using input variables
- Working with PROC MI
Summary and Conclusion for Government
Requirements
- Familiarity with navigating directory structures
Audience for Government
- Data Analysts
Testimonials (4)
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
Share example of application
Course - Alteryx for Data Analysis
Very clearly articulated and explained
Harshit Arora - PwC South East Asia Consulting
Course - Alteryx for Developers
Linear regression - the algorithm to predict the trend
