Data Science with SAS
Enroll Now
Catogory
Data Science & Business Intelligence
Duration Time
45 hours
Price
Rs. 2000
EduInPro’s Data Science with SAS Certification Training is a thoughtfully designed course that enables learners to work with both technical and non-technical background to make a transition into the analytics industry with the correct skill sets. It is designed in a way that post completion of the program, learners be prepared to devise solutions for real-time problems in the industry through SAS. The course covers all the topics from SAS Base Programming Certification major coverage from the SAS Advanced Programming and essential procedures and techniques from SAS Statistical Business Analysis: Regression and Modeling.
You’ll learn how to apply data manipulation and optimization techniques; advanced statistical concepts like clustering, linear regression and decision trees; data analysis methods to solve real-world business problems and predictive modeling techniques. This SAS course will give you practical knowledge you can apply on your next data analysis job.
The EduInPro approach on Data Science with SAS Certification training:
-
Describe the role of data scientists, various analytics techniques, and widely used tools.
-
Provide an understanding of SAS, the role of GUI, library statements, importing and exporting of data and variable attributes.
-
Concepts of statistics, hypothesis testing, and advanced statistics techniques like clustering, decision trees, linear regression, and logistic regression.
-
Various techniques for combining and modifying datasets like concatenation, interleaving, one-to-one merging and reading.
-
SAS functions and procedure for data manipulation.
-
PROC SQL, its syntax, and master the various PROC statements and subsequent statistical procedures used for analytics including PROC UNIVARIATE, PROC MEANS, PROC FREQ, PROC CORP, and more.
-
Provide an understanding on the power of SAS Macros and how they can be used for faster data manipulation and for reducing the amount of regular SAS code required for analytics
-
Various types of Macro variables, Macro function SYMBOLGEN System options, SQL clauses, and the %Macro statement
-
Model, formulate, and solve data optimization by using SAS and OPTMODEL procedure.
Data Science with SAS Modules
Overview of SAS
- Introduction and History of SAS
- Significance of SAS software solutions in various industries
- Demonstrate SAS Capabilities
- Job Profile / career opportunities with SAS worldwide?
Base SAS Fundamentals
- Explore SAS Windowing Environment
- SAS Tasks
- Working with SAS Syntax
- Create and submit a SAS sample program
Reading SAS data set
- Introduction to reading data
- Examine structure of SAS data set
- Understanding of SAS works
Reading Excel worksheets
- Using Excel data as input
- Create as sample program to import and export excel sheets
Reading Raw data from External File
- Introduction to raw data
- Reading delimited raw data file (List Input)
- Using standard delimited data as input
- Using nonstandard delimited data as input
- Reading raw data aligned to columns (Fixed or column input)
- Reading raw data with special instructions (Formatted input)
Writing to an External file
- Write data values from SAS data set to an external file
Data transformations (Data step processing)
- Create multiple output datasets from single SAS dataset
- Writing observations to one or more SAS datasets
- Controlling which observations and variables to be written to output data
Processing Data Iteratively
- Iterative DO loop processing with END statement
- DO WHILE & DO UNTIL Statement
- SAS Array statement
Summarizing data
- Creating and Accumulating total variable (Retain)
- Using Assignment statement
- Accumulating totals for a group of data (BY group)
Manipulating Data
- Sorting SAS data sets
- Manipulating SAS data values
- Presentation of user defined values /data/currency values using FORMAT procedure
- SAS functions to manipulate char and num data
- Convert data type form char-to num and num-to-char
- SAS variables lists/ SAS variables lists range
- Debugging SAS program
- Accessing observations by creating index
Combining SAS data sets
- Concatenation
- Interleaving
- One to one reading
- One to one merging (with non-matching)
- Match merging (Merging types with IN=option)
SAS Access & SAS Connect
- Validating and cleaning data
- Detect and correct syntax errors
- Examining data errors
Producing detailed /Summary Reports
- Freq Report
- Means Report
- Tabulate Report
- Proc report
- Summary report
- Univariate report
- Contents report
- Print report
- Compare proc
- Copy proc
- Datasets proc
- Proc append
- Proc delete
Generating Graphical reports using
- Producing Bar and Pie charts (GCHART Proc)
- Producing plots (GPLOT Proc)
- Presenting Output Report result in:
- Text files
- Excel
- HTML Files
Basics Queries
- Proc SQL syntax overview
- Specifying columns/creating new columns
- Specifying rows/subsetting on rows
- Ordering or sorting data
- Formatting output results
- Presenting detailed data
- Presenting summarized data
SQL Joins (Combining SAS data sets using SQL Joins)
- Introduction to SQL joins
- Types of joins with examples
- Simple to complex joins
- Choosing between data step merges and SQL joins
Additional SQL Procedures features
- Creating views with SQL procedure
- Dictionary tables and views
- Interfacing Proc SQL with the macro programming language
- Creating and maintaining indexes
- SQL Pass-Through facility
SAS Macro Language
- Introduction to macro facility
- Generate SAS code using macros
- Macro compilation
- Creating macro variables
- Scope or macro variables
- Global/Local Macro variables
- User defined /Automatic Macro variables
- Macro variables references
- Combing macro variables references with text
- Macro functions
- Quoting (Masking)
- Creating macro variables in Data step (Call SYMPUT Routine)
- Obtaining variable value during macro execution (SYMGET function)
- Creating macro variables during PROC SQL execution (INTO Clause)
- Creating a delimited list of values
- Macro parameters
- Strong Macro using Autocall Features
- Permanently storing and using stored compiled macro program
- SAS Macro debugging options to track problems
Basics Statistics
- Standard deviation
- Correlation Coefficients
- Outliers
- Linear regressions
- Clustering
- Chi Square
Course Outline
- Overview of SAS
- Introduction and History of SAS
- Significance of SAS software solutions in various industries
- Demonstrate SAS Capabilities
- Job Profile / career opportunities with SAS worldwide?
- Base SAS Fundamentals
- Explore SAS Windowing Environment
- SAS Tasks
- Working with SAS Syntax
- Create and submit a SAS sample program
- Data Access & Data Transformation
- Accessing SAS Data libraries
- Getting familiar with SAS Data set
- Reading SAS data set
- Introduction to reading data
- Examine structure of SAS data set
- Understanding of SAS works
- Reading Excel worksheets
- Using Excel data as input
- Create as sample program to import and export excel sheets
- Reading Raw data from External File
- Introduction to raw data
- Reading delimited raw data file (List Input)
- Using standard delimited data as input
- Using nonstandard delimited data as input
- Reading raw data aligned to columns (Fixed or column input)
- Reading raw data with special instructions (Formatted input)
- Writing to an External file
- Write data values from SAS data set to an external file
- Data transformations (Data step processing)
- Create multiple output datasets from single SAS dataset
- Writing observations to one or more SAS datasets
- Controlling which observations and variables to be written to output data
- Creating subset of observations using
- Where condition
- Conditional processing using: IF statements
- Processing Data Iteratively
- Iterative DO loop processing with END statement
- DO WHILE & DO UNTIL Statement
- SAS Array statement
- Summarizing data
- Creating and Accumulating total variable (Retain)
- Using Assignment statement
- Accumulating totals for a group of data (BY group)
- Manipulating Data
- Sorting SAS data sets
- Manipulating SAS data values
- Presentation of user defined values /data/currency values using FORMAT procedure
- SAS functions to manipulate char and num data
- Convert data type form char-to num and num-to-char
- SAS variables lists/ SAS variables lists range
- Debugging SAS program
- Accessing observations by creating index
- Restructuring a SAS data set
- Rotating with the data step
- Using the transpose procedure
- Combining SAS data sets
- Concatenation
- Interleaving
- One to one reading
- One to one merging (with non-matching)
- Match merging (Merging types with IN=option)
- SAS Access & SAS Connect
- Validating and cleaning data
- Detect and correct syntax errors
- Examining data errors
- Analysis & Presentation
- SAS/REPORTS SAS/GRAPH
- SAS/STATS SAS/ODS
- Producing detailed /Summary Reports
- Freq Report
- Means Report
- Tabulate Report
- Proc report
- Summary report
- Univariate report
- Contents report
- Print report
- Compare proc
- Copy proc
- Datasets proc
- Proc append
- Proc delete
- Generating Statistical Reports using
- Regression proc
- Uni/Multivariate proc
- Anova proc
- Generating Graphical reports using
- Producing Bar and Pie charts (GCHART Proc)
- Producing plots (GPLOT Proc)
- Presenting Output Report result in:
- Text files
- Excel
- HTML Files
- SAS/SQL Programming
- Introduction and overview to SQL procedure
- Proc SQL and Data step comparisons
- Basics Queries
- Proc SQL syntax overview
- Specifying columns/creating new columns
- Specifying rows/subsetting on rows
- Ordering or sorting data
- Formatting output results
- Presenting detailed data
- Presenting summarized data
- Sub Queries
- Non correlated sub queries
- Correlated sub queries
- SQL Joins (Combining SAS data sets using SQL Joins)
- Introduction to SQL joins
- Types of joins with examples
- Simple to complex joins
- Choosing between data step merges and SQL joins
- SET Operators
- Introduction to set operations
- Except/Intersect/Union/Outer union operator
- Additional SQL Procedures features
- Creating views with SQL procedure
- Dictionary tables and views
- Interfacing Proc SQL with the macro programming language
- Creating and maintaining indexes
- SQL Pass-Through facility
- SAS Macro Language
- Introduction to macro facility
- Generate SAS code using macros
- Macro compilation
- Creating macro variables
- Scope or macro variables
- Global/Local Macro variables
- User defined /Automatic Macro variables
- Macro variables references
- Combing macro variables references with text
- Macro functions
- Quoting (Masking)
- Creating macro variables in Data step (Call SYMPUT Routine)
- Obtaining variable value during macro execution (SYMGET function)
- Creating macro variables during PROC SQL execution (INTO Clause)
- Creating a delimited list of values
- Macro parameters
- Strong Macro using Autocall Features
- Permanently storing and using stored compiled macro program
- SAS Macro debugging options to track problems
- Basics Statistics
- Standard deviation
- Correlation Coefficients
- Outliers
- Linear regressions
- Clustering
- Chi Square
What do I need to do to unlock my Eduinpro certificate?
Online Classroom:
- Attend one complete batch
- Successful completion and evaluation of any one of the given projects
Online Self-learning:
- Complete 85% of the course
- Successful completion and evaluation of any one of the given projects
Featured Review
Anup Acharya
I Attended a 2 day weekend course by EduInPro for the Data Science with SAS certification. The instructor was very knowledgeable and engaging. Had Excellent learning and experience.
Bhibudatta
I attended training for Data Science with SAS and the training was very interactive and helpful. Got clarity on many concepts related to Scrum Master role.
Sreeram Narayan
I came across EduInPro for Data Science with SAS . The training was interesting and trainer made the class fun and interesting and the sessions very knowledgeable on the topic!
Namratha Kulkarni
Course with EduInpro was a well-organized one with an excellent tutor. The course included both theoretical and practical real-life cases and hands-on sessions which made training interesting.
Iqbal Arif
EduInPro’s Data Science with SAS was excellent and it got numerous concepts together in a simple, practical and detailed package. I highly recommend EduInPro’s PMP training even if you don't plan to sit for the PMP exam.
Ruthvik Sharma
I came across EduInPro’s Data Science with SAS online and its self-paced module encouraged me to take up the course and made me more proactive with my learning. I took detailed notes, and attended the classes to fit in with my busy schedule and was happy with the course.
Garima Khera
EduInPro’s Data Science with SAS training were so well designed. The hands-on projects helped me understand the theory sessions in depth and apply them on my website.
FREQUENTLY ASKED QUESTIONS
To run SAS, you need to download and install the SAS university edition from http://www.sas.com/en_us/software/university-edition.html (make this link no-follow)
Yes, EduInPro’s training and course materials guarantee success with the Data Science with SAS certification exam.
Upon successful completion of the Data Science with SAS Certification training, after the evaluation project is submitted and evaluated, and after passing the online exam with a minimum score of 75%, participant will receive a Data Science with SAS Certificate from EduInPro, which states that you are a Certified Data Scientist with SAS.
Contact Us
80-95942111
Request more information
Continue with Google