Introduction to the SQL Procedure
o What is SQL?
o What is the SQL Procedure?
o Terminology
o Comparing PROC SQL with the SAS DATA step
o Note about the Example Table


Retrieving Data From a Single Table
o Overview of the select Statement
o Selecting Columns in a Table
o Creating New Columns
o Sorting Data
o Retrieving rows that satisfy a Condition
o Summarizing Data
o Grouping Data
o Filtering Grouped Data

Retrieving Data from Multiple Tables
o Introduction
o Selecting Data from More Than One Table by Using joins
o Using Subqueries to Select Data
o When to Use Joins and Subqueries
o Combining Queries with Set Operators

Creating and Updating Tables and Views
o Introduction
o Creating Tables
o Inserting Rows into Tables
o Updating Data Values in a Table
o Deleting Rows
o Altering Columns
o Creating an Index
o Deleting a Table
o Using SQL Procedure Tables in SAS Software
o Creating and Using Integrity Constraints in a Table
Programming with the SQL Procedure
o Introduction
o Using Proc SQL Options to Create and Debug Quires
o Improving Query Performance
o Accessing SAS System Information Using DICTIONRY Tables
o Using Proc SQL with the SAS Macro Facility
o Formatting PROC SQL output Using the Report Procedure
o Accessing a DBMS with SAS/ACCESS Software

Practical Problem-Solving with PROC SQL
o Overview
o Computing a Weighted Average
o Comparing Tables
o Overlaying Missing Data Values
o Computing Percentages within Subtotals
o Counting Duplicate Rows in a Table
o Expanding Hierarchical Data in a Table
o Summarizing Data in Multiple Columns
o Creating a Summary Report
o Creating a Customized Sort Order
o Conditionally Updating a Table
o Updating a Table with Values from Another Table
o Creating and Using Macro Variables

SAS ESSENTIALS : Programing-I
Chapter-1
Introduction
1.1 An Overview of the SAS System
Chapter-2
Getting Started With the SAS® System
2.1 Introduction to SAS Programs
2.2 Running SAS Programs
2.3 Mastering Fundamental Concepts
2.4 Diagnosing and Correcting Syntax Errors
2.5 Exploring Your SAS Environment
Chapter-3
Getting familiar with SAS Data Sets
3.1 SAS Data Libraries
Chapter-4
Producing List Report
4.1 Getting Started With the PRINT Procedure
4.2 Sequencing and Grouping Observations
4.3 Identifying Observations
4.4 Special WHERE Statement Operators

Chapter-5
Enhancing Output
5.1 Customizing Report Appearance
5.2 formatting Data Values
5.3 Creating HTML Reports
Chapter-6
Creating SAS® Data Sets
6.1 Reading Raw Data Files: Column Input
6.2 Reading Raw Data Files: Formatted Input
6.3 Examining Data Errors

6.4 Assigning Variable Attributes
6.5 Changing Variable Attributes
6.6 Reading Excel Spreadsheets
Chapter-7
DATA Step Programming
7.1 Reading SAS Data Sets and Creating Variables
7.2 Conditional Processing
7.3 Dropping and Keeping Variables
7.4 Reading Excel Spreadsheets Containing Date Fields

Chapter-8
Combining SAS Data Sets
8.1 Concatenating SAS Data Sets
8.2 Merging SAS Data Sets
8.3 Combining SAS Data Sets : Additional Features
Chapter-9
Producing Summary Reports
9.1 Introduction of Summary Reports.
9.2 Basic Summary Reports
9.3 The Report Procedure
9.4 The Tabulate Procedure
Chapter-10
Introduction to Graphics
10.1 Producing Bar and pie Chart
10.2 Enhancing output
10.3 Producing Plots

SAS Programing II

Chapter-1
Introduction

1.1 Overview
1.2 Review of SAS basics
1.3 Review of DATA Step Processing
1.4 Review of Displaying SAS Data Sets
1.5 Working with Existing SAS Data Sets

Chapter-2
Controlling Input and Output
2.1 Outputting Multiple Observations
2.2 Writing to Multiple SAS Data Sets
2.3 Selecting Variables and Observations
2.4 Writing to an External File

Chapter-3
Summarizing Data
3.1 Creating an Accumulating Total variable
3.2 Accumulating Totals for a Group of Data

Chapter-4
Reading & Writing Different Types of Data
4.1 Reading Delimited Raw Data Files
4.2 Controlling When a Record Loads
4.3 Reading Hierarchical Raw data Files
Chapter-5
Data Transformations
5.1 Introduction
5.2 Manipulating Character values
5.3 Manipulating Numeric values
5.4 Manipulating Numeric values based on Dates
5.5 Converting variable Type

Chapter-6
Debugging Techniques
6.1 Using the PUT Statement
6.2 Using the DEBUG Option

Chapter-7
Processing Data Iteratively
7.1 Do Loop Processing
7.2 SAS Array Processing
7.3 Using SAS Arrays

Chapter-8
Combining SAS® Data Sets
8.1 Match-merging Two or more SAS Data Sets
8.2 Simple Joins Using the SQL Procedure

• SAS Macro Overview
• SAS Macro Variables
• Scope of Macro variables
• Defining SAS Macros
• Inserting Comments in Macros
• Macros with Arguments
• Conditional Macros
• Macros Repeating PROC Execution
• Macro Language
• SAS Macro Processor