SAS originally stood for "Statistical Analysis System", which as the name suggests was used for Statistical analysis. Today it has evolved to become a ubiquitous Business Intelligence (BI) tool which is used for Data analysis, reporting, predictive modelling, data mining, econometric and time series analysis...pretty much anything and everything related to Data Analytics. This course is our Essential Introduction to the SAS System. The course covers all you need to know to get started with SAS quickly and easily.
1. BASE SAS
Topics - Introduction To SAS System & Architecture, History And Various Modules, Features, Variables & SAS, Syntax Rules, SAS Data Sets, Data Set Options, Operators, Reading Raw Data, Infile Statement With Options, Working With External Files & Options, Multiple Observations, Input Styles, Select Statement, Leave and Continue Statements, Creating & Redefining Variables, Where Statement, If – Then Else Statement, Output Statement, Put Statement, Do Loops, Modifying And Combining Data Sets, Updating Master Data Set, SAS Functions.
2. BASE SAS PROCEDURES
Topics - Proc sort, Proc Print, Proc Means, Proc Freq, Proc Plot, Proc Chart, Proc Copy, Proc Summary, Proc Append, Proc Datasets, Proc Contents, Proc Delete, Proc Format, Proc Import, Proc Export.
3. ORACLE - SQL CONCEPTS
Topics - Introduction, History, Features, Sql Command Set, Operators In Sql, Order By Clause, Group By Clause, Having Clause, Distinct Clause, Create and Insert, Deleting, Populating And Updating.
Topics - Introduction To SAS/Sql, Features, Uses, Terminology, Data Types, Key Words, & Operators, Functions, Predicates, Formatting Output, Group By Clause, Order By Clause, Having Clause, Case Expression And Conditional Logic, Creating ,Populating & Deleting Tables, Alter Table Statement, Changing Column’s Length, Joins, Renaming A Table & Columns, Views.
Topics - Gchart Procedure, Vertical, Horizontal, Pie, Donut, G3d, Group, Subgroups, Gplot Procedure, Multiple Plots & Overlay, Symbol Statement, Title And Footnote Statements, Goptions.
Topics - Frequency Report, One-Way Frequency Report, Cross Tabular Frequency Report, Summary Statistics, Creating A List Report, Define Statement, Order Usage and Group, Printing Grand Totals, Rbreak Statement, Tabulate Procedure, Analysis Variables with options, Summary Statistics.
Topics - Proc Univariate, Proc Corr, Proc Reg.
Topics - Creating Rtf File, Creating Html File, Creating Pdf File, Creating XML File, Creating templates.