In this Data Science with SAS Training, you’ll become an expert in analytics techniques using the SAS data science tool. It offers a comprehensive learning foundation that you can build your analytics career on. Big Data Preparation, Statistics, and Visual Exploration, and also you can learn Predictive Modeling, Advanced Predictive Modeling.
Introduction
♦ 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
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.
We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.
Copyright © 2017 - Developed by Infihive Consulting Services LLC changes