|

Base SAS 9.2 Procedures Guide

The SQL Procedure

Overview: SQL Procedure
Syntax: SQL Procedure
		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
SQL Procedure Component Dictionary
		BETWEEN condition
		BTRIM function
		CALCULATED
		CASE expression
		COALESCE Function
		column-definition
		column-modifier
		column-name
		CONNECTION TO
		CONTAINS condition
		EXISTS condition
		IN condition
		IS condition
		joined-table
		LIKE condition
		LOWER function
		query-expression
		sql-expression
		SUBSTRING function
		summary-function
		table-expression
		UPPER function
PROC SQL and the ANSI Standard
Examples: SQL Procedure
		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

|

|

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