Introduction

• What is SAS
• SAS vs. other tools
• SAS on the mainframe vs. other environments
• SAS programs
• SAS datasets
• Types of data in SAS
• SAS variables and names
• SAS data libraries
• The SAS log
• PROC CONTENTS

Getting your data into SAS

• Reading data from flat files
• INFILE and INPUT statements
• List, column and formatted input
• Input formats (INFORMATS)
• Multiple observations per record (OUTPUT statement)
• Holding the current input record (the trailing @)
• Browsing SAS datasets in TSO
• Backing up SAS datasets
• Debugging a SAS program

Working with your data

• Assignment statements
• Functions
• Character handling
• Arithmetic
• Date / time
• IF statements
• Looping: DO and END statements
• Working with date and time values
• RETAIN and SUM statements
• Arrays

Sorting, printing and summarizing your data

• Using SAS Procedures
• PROC SORT
• PROC PRINT
• Output formats
• Creating your own formats: PROC FORMAT
• PUT and INPUT functions (table lookup)
• Summarizing your data: PROC MEANS and PROC FREQ

Modifying and combining SAS datasets

• SET statement
• MERGE statement
• OUTPUT statement
• Using "IN=" and other SAS dataset options
• Automatic variables

Common SAS applications

• Collapsing data
• "top ten" report
• Producing a report from multiple data sources
• Maintaining historical data
• Using a flat file with multiple record types

Charts and graphs

• PROC CHART
• PROC PLOT

Using SAS to access DB2 tables