Data Science with SAS
-
PARAMETERS SPECIFICATIONS
-
Tools Used SAS
-
Learning Mode (Classroom – Instructor based)
-
Duration 48 – 52 Hours
-
Batch size 5- 8 Students
-
Location Delhi (Saket)
-
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
-
Connecting to a DBMS Using the Libname Statement
Retrieving Data from Multiple tables
-
Inner Join
-
Outer Join (Right, Left, Full)