SAS Fundamentals Course Outline
Do you want to create data analysis reports without writing a line of code?
This course introduces SAS programming using SAS Studio, a free data science web browser-based product for educational and non-commercial purposes. The power of SAS Studio comes from its visual point-and-click user interface that generates SAS code. It is easier to learn SAS Studio than to learn R and Python to accomplish data cleaning, statistics, and visualization tasks. If you use ay other SAS product, this course will cover the SAS programming syntax and fundamentals needed to do your data reports.
The course includes a case study about analyzing the data required for predicting the results of presidential elections in the state of Maine for 2016 and 2020. In addition to the presidential elections, the course provides real-life examples including analyzing stocks, oil and gold prices, crime, marketing, and healthcare. You will see data science in action and how easy it is to perform complicated tasks and visualizations in SAS Studio.
You will learn, step-by-step, how to do visualizations, including maps. In most cases, you will not need a line of code as you work with the SAS Studio graphical user interface. The course includes explanations of the code that SAS Studio generates automatically. You will learn how to edit this code to perform more complicated advanced tasks.
Become familiar with SAS Studio IDE
Understand essential visualizations
Know the fundamental statistical analysis required in most data science and analytics reports
Clean the most common data set problems
Use linear progression for data prediction
Write programs in SAS
Get introduced to SAS-Viya, which is more potent than SAS studio
Who this class is for?
It is for data scientists and analytics.
No prior knowledge of SAS is required.
Number of Days
Part I: Basics
Data Science in Action
Data Science Process
Case Study: Presidential Elections in Maine
Winning Candidates in 2012
Factors Affecting Maines Economy
My 2016 Predictions
My 2020 Predictions
How Do You Install SAS Studio?
What Is SAS and SAS Studio?
Main Components of a SAS Program
Accessing Your Existing Local Files
Accessing Data in SAS Libraries
Create a New Library
Add a New Table to the Library
Scatter Plot Code
Scatter Plot Relationships
Plotting More Than One Scatter Plot in the Same Image
How Do You Sort A Bar Chart?
Create a Histogram Using a Bar Chart
Statistical Analysis and Linear Models
Advanced Data Preprocessing and Feature Engineering
How to Represent Missing Values in Raw Data
PROC SQL Statement
Preparing Data for Analysis
Create New Variables
Rearrange the Dataset Variables
IF (Condition) Without THEN statement
Simple Linear Regression
Multiple Linear Regression
We will work on real data set to practice by hand everything learnt throughout the course
Clean the data column by column
Do Correlation between the outcome and the variables
Analyze the results and write a report explaining the numbers
View outline in Word