Chapter 1: Introduction
• SAS Language
• SAS Program (Steps & Statements)
• SAS Layout
• Comments
• Processing Modes
• SAS Environment
• Data Types
• Work flow in SAS

Chapter 2: Getting Started using SAS
• Temporary Vs Permanent Datasets
• Library & Referencing
• Examining SAS datasets
• Browsing a library
• System Options
• Dates in SAS
• Formats
• Date Formats

Chapter 3: Getting your data into SAS
• Creating SAS data sets from raw data files
• DATALINES Statement
• INPUT Statement
• Length Statement
• List Input
• INFILE Statement
• DLM option
• Date informats
• Column Input
• Formatted Input
• SET Statement
• Reading Multiple lines of Raw data per Observation
• Reading Multiple observations per line of DATA
• Reading part of a Raw Data file

Chapter 4: Working with your data in SAS
• Creating and Redefining Variables
• Assignment Statements
• SAS Functions (Character, Numeric and Date Functions)
• Subsetting Data (Observation &Variables)
• Using IF – Then Statements
• Do loops
• Deleting Observations
• Customizing Data set
• Permanent Labels

Chapter 5: Reporting your data in SAS
• Using SAS Procedures
• Sub setting in procedures with WHERE statement
• Sorting your DATA
• Printing your Data Set
• Changing the appearance of printed values using formats
• Customizing Titles and footnotes
• Creating your own formats

Chapter 6: Modifying and Combining SAS Data sets
• Modifying Data set using SET statement
• Combining DATA sets using a One -to- One Match Merge
• Combining DATA sets using a One -to- Many Match Merge
• Combining DATA setsof Non Matches
• Merging Summary Statistics with original data
• Writing multiple data sets using OUTPUT statement
• Tracking and Selecting Observations With Where = option
• Tracking and Selecting Observations With IN = option
• Changing Observations to Variables
• Using SAS Automatic Variables

Chapter 7: Macros
• Macro Concepts
• Process Flow
• Macro Variables
• Macro Statement
• Macro Functions
• Macro Programs
• Using Conditional and Iterative Processing in Macro programs

Chapter 8: SQL
• Getting Started using SQL
• Writing Basic Queries
• Displaying Query Results
• SQL Joins
• SET Operators
• Creating Tables
• Using Macro Language with

PROC SQL
Chapter 9: Debugging SAS Programs
• Writing SAS programs that works
• Fixing Programs that don’t work
  What Next? – Road Map