Session : 1 – 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?
Session : 2 – Base SAS Fundamentals
- Explore SAS Windowing Environment
- SAS Tasks
- Working with SAS Syntax
- Create and submit a SAS sample program
Session : 3 – Data Access & Data Transformation
- Accessing SAS Data libraries
- Getting familiar with SAS Data set
Session : 4 – Reading SAS data set
- Introduction to reading data
- Examine structure of SAS data set
- Understanding of SAS works
Session : 5 – Reading Excel worksheets
- Using Excel data as input
- Create as sample program to import and export excel sheets
Session : 6 – 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)
Session : 7 – Writing to an External file
- Write data values from SAS data set to an external file
Session : 8 – 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
Session : 9 – Creating subset of observations using
- Where condition
- Conditional processing using: IF statements
Session : 10 – Processing Data Iteratively
- Iterative DO loop processing with END statement
- DO WHILE & DO UNTIL Statement
- SAS Array statement
Session : 11 – Summarizing data
- Creating and Accumulating total variable (Retain)
- Using Assignment statement
- Accumulating totals for a group of data (BY group)
Session : 12 – 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
Session : 13 – Restructuring a SAS data set
- Rotating with the data step
- Using the transpose procedure
Session : 14 – Combining SAS data sets
- Concatenation
- Interleaving
- One to one reading
- One to one merging (with non-matching)
- Match merging (Merging types with IN=option)
Session : 15 – SAS Access & SAS Connect
- Validating and cleaning data
- Detect and correct syntax errors
- Examining data errors
Session : 16 – Analysis & Presentation
Session : 17 – SAS/REPORTS SAS/GRAPH
Session : 18 – SAS/STATS SAS/ODS
Session : 19 – 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
Session : 20 – Generating Statistical Reports using
- Regression proc
- Uni/Multivariate proc
- Anova proc
Session : 21 – Generating Graphical reports using
- Producing Bar and Pie charts (GCHART Proc)
- Producing plots (GPLOT Proc)
- Presenting Output Report result in:
- PDF
- Text files
- Excel
- HTML Files
Session : 22 – SAS/SQL Programming
- Introduction and overview to SQL procedure
- Proc SQL and Data step comparisons
Session : 23 – 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
Session : 24 – Sub Queries
- Non correlated sub queries
- Correlated sub queries
Session : 25 – 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
Session : 26 – SET Operators
- Introduction to set operations
- Except/Intersect/Union/Outer union operator
Session : 27 – 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
Session : 28 – 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
Session : 29 – Basics Statistics
- Standard deviation
- Correlation Coefficients
- Outliers
- Linear regressions
- Clustering
- Chi Square
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.
