After completing SAS: Inputting Data and PROC SQL, the user should be able to:

	Describe various input styles used with the INPUT statement
	Use the INPUT and INFILE statements to handle external files
	Explain the basics of using SQL with SAS
	Use PROC SQL to query data sets and generate reports

Input Styles

	Overview
	List input
	Column input
	Formatted input
	Named input

Reading External Files

	Multiple records per observation
	Multiple reads per record
	INFILE statement options

Introduction to SQL

	SQL basics
	SELECT statement – required clauses
	SELECT statement – optional clauses

Using PROC SQL

	Joining tables
	Creating tables, views and indexes
	Modifying tables

This course has the following features:

	Exercises that allow users to practice in SAS
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to SAS
	A glossary
	A Skill Assessment

	SAS: Introduction (SAS601)
	SAS: Using SAS (SAS602)
	SAS: Data Manipulation (SAS603)
	SAS: DATA Step Programming (SAS604)
	SAS: Results (SAS605)
	SAS: Display Manager System (SAS606)
	SAS: Data Libraries (SAS607)

SAS: Combining and Updating Data Sets (SAS609)

SAS is a registered trademark of SAS Institute Inc.