Course includes Live scenarios, Case Studies, Project, Assessments, Mock Interview.
Study Material PPTs, Doc, Data, PDFs etc.
Target Audience:
Any graduate - No prior knowledge of Data Science / Analytics is required
What is SAS?
SAS is licensed based software suite developed by SAS Institute for advanced analytics, Multivariate analyses, Business Intelligence, Data Management, and Predictive analytics. SAS is widely uses by Data scientists, statisticians, Researchers and Data analysts—anyone who needs to make sense/insight of data can use SAS for Statistical Analysis, Data visualization, and Predictive Modeling. SAS is a leader in business analytics and No. 1 in Advanced and Predictive Analytics market share. SAS held a 30.5 percent market share for 2016 in the advanced and predictive analytics category.
Job Profiles in SAS:
SAS Programmer/Reporter
Data Analyst/Miner
Data Modeler
Data Scientist
ML specialist
NLP specialist and many more.
*****COURSE CONTENT*****
TECHNICAL
Introduction
Introduction to SAS Programming
Working in the SAS Environment
Working with the windows
Enhance editor window
Log window
Output window
Result window
Explorer window
Program editor window
Overview of libraries, Dataset, Variables and Metadata
Datasets
Referencing Files in SAS Libraries
Contents
Variable Names and Values
Data step execution
Data Handling
Basic concepts
Creating a SAS Programs
Components of SAS Programs
Characteristics of SAS Programs
Layout of SAS Programs
Understanding Data step Processing
Program data vector(PDV)
Compilation Phase
Execution Phase
Reading Raw Data from External File
Infile statement
Filename statement
Options & Titles
Global options
Local Options
Titles
Statements
Global Statements
Local Statements
Input Styles
List input
Column
Formatted input
Modified input
Named input
Trailing
@
@@
Informats and Formats
Informats
Character informats
Numeric informats
Date and time informats
Formats
Character formats
Numeric formats
Date and time formats
Functions
Arithmetic Functions
String Functions
Date and Time Functions
Combining SAS Datasets
Concatenating
Merging
One-to-one merging
One-to-many merging
Many-to-one merging
Many-to-many merging
Matching merging
Interleaving
Updating
Control Statements
If statement and if else statement
If then else statement
Where statement
Loops (do, do until, do while)
Writing Data to External Files
File Statement
Put Statement
Output Delivery System (ODS)
Fundamentals of the ODS
ODS and the Data step
Syntax for ODS Enhanced features in a Data step
Introduction to ODS language Statements
Dictionary of ODS language Statements
Debugging of Errors
Writing SAS programs that work
Fixing programs that Don’t work
Types of Errors
Working with SAS Inbuilt Procedures
Proc Print Proc Transpose
Proc Sort Proc Freq
Proc Contents Proc Formats
Proc Append Proc Tabulate
Proc Import Proc Report
Proc Export Proc Printto
Proc Datasets Proc Means
Proc Surveyselect Proc Summary
Proc Ttest Proc Anova and many more.
SAS/GRAPH
Introduction to Graphs
Types of Graphs
Chart
Plot
Illustration of axis options
Illustration of symbol options
SAS/STAT
Introduction to Statistics
Producing Descriptive Statistics
Computing Statistics for Numeric Variables
Working with Inferential Statistics
SAS/MACROS
Introduction to Macro Language Elements
Introduction to Macro Variables
Automatic Macro Variables
User defined Macro Variables
Introduction to Macro Processing
Macro Statements
Macro Statements
SAS/SQL
Introduction to Proc SQL
Creating tables
Inserting data into tables
Alter the tables & etc…
Update
Modifying the tables
Retrieving Data from Single Table
Integration of Database
Connecting to a DBMS Using the SQL Procedure Pass-Through Facility
Connecting to a excel Using the SQL Procedure Pass-Through Facility
Connecting to a access Using the SQL Procedure Pass-Through Facility