Lesson 1: Introduction to SAS
o Getting started with SAS, various SAS Windows – Log, Explorer, Output, Search, Editor, etc.
o Working with data sets, overview of SAS Functions, Library Types and programming files.
Lesson 2: SAS Enterprise Guide
o Base SAS
o learning about Proc copy
o Import/Export Wizard
o reading and sub setting the data set
o various statements like WHERE, SET
o various operators like Arithmetic, Logical, Comparison and operands.
Lesson 3: SAS Operators & Functions, Using Variables
o Introduction to Base SAS
o various SAS Operators – Arithmetic, Logical, Comparison
o various SAS Functions – NUMERIC, CHARACTER, IS NULL, CONTAINS, LIKE, etc.
o Defining and Using KEEP and DROP statements, apply these statements, Format and Labels in SAS.
Lesson 4: Compilation & Execution
o Understanding about Input Buffer
o PDV (Backend
o learning what is Missover.
Lesson 5: : Creation and Compilation of SAS Data sets
o Understanding Delimiter
o dataline rules
o Delimiter DSD
o raw data files and execution
o list input for standard data.
Lesson 6: Deploying SAS Procedures
o The various SAS standard Procedures built-in for popular programs – PROC SORT, PROC FREQ, PROC SUMMARY, PROC RANK, PROC EXPORT, etc.
Lesson 7: Input statement and formatted input
o Reading standard and non-standard numeric inputs with Formatted inputs
o Column Pointer Controls, Controlling while a record loads
o Line pointer control / Absolute line pointer control
o Single Trailing
o Multiple IN and OUT statements
o DATA LINES statement and rules
o List Input Method
o comparing Single Trailing and Double Trailing.
Lesson 8: SAS FORMAT And SAS Graphs
o SAS FORMAT statements – standard and user-written
o associating a format with a variable
o working with SAS FORMAT
o deploying it on PROC Data sets
o comparing ATTRIB and FORMAT statements.
o Understanding PROC GCHART
o various Graphs
o Bar Charts – Pie, Bar, 3D
o plotting variables with PROC GPLOT
Lesson 9: Interactive Data Processing
o SAS advanced data discovery and visualization
o point-and-click analytics capabilities
o powerful reporting tools.
Lesson 10: Advanced Base SAS
o Base SAS web-based interface and ready-to-use programs
o advanced data manipulation
o storage and retrieval
o descriptive statistics.
Lesson 11: Summary Reports- Producing and Enhancing
o Report Enhancement
o Global Statements
o User-defined Formats
o PROC SORT
o ODS Destinations
o ODS Listing
o PROC FREQ
o PROC Means
o Other Procedures.
Lesson 12: Getting started with Data Transformation Function
o Character Functions
o Numeric Functions
o Converting Variable Type.