SAS Procedures Guide

The SQL Procedure

Overview
Procedure Syntax
		PROC SQL Statement
		ALTER TABLE Statement
		CONNECT Statement
		CREATE INDEX Statement
		CREATE TABLE Statement
		CREATE VIEW Statement
		DELETE Statement
		DESCRIBE Statement
		DISCONNECT Statement
		DROP Statement
		EXECUTE Statement
		INSERT Statement
		RESET Statement
		SELECT Statement
		UPDATE Statement
		VALIDATE Statement
Component Dictionary
		BETWEEN condition
		CALCULATED
		CASE expression
		column-definition
		column-modifier
		column-name
		CONNECTION TO
		CONTAINS condition
		DICTIONARY tables
		EXISTS condition
		IN condition
		IS condition
		joined-table
		LIKE condition
		query-expression
		sql-expression
		summary-function
		table-expression
Concepts
PROC SQL and the ANSI Standard
Examples
		Example 1: Creating a Table and Inserting Data into It
		Example 2: Creating a Table from a Query's Result
		Example 3: Updating Data in a PROC SQL Table
		Example 4: Joining Two Tables
		Example 5: Combining Two Tables
		Example 6: Reporting from DICTIONARY Tables
		Example 7: Performing an Outer Join
		Example 8: Creating a View from a Query's Result
		Example 9: Joining Three Tables
		Example 10: Querying an In-Line View
		Example 11: Retrieving Values with the SOUNDS-LIKE Operator
		Example 12: Joining Two Tables and Calculating a New Value
		Example 13: Producing All the Possible Combinations of the Values in a Column
		Example 14: Matching Case Rows and Control Rows
		Example 15: Counting Missing Values with a SAS Macro

Book Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.