SAS Institute. The Power to Know

Base SAS(R) 9.2 Procedures Guide

Previous Page | Next Page

Base SAS 9.2 Procedures Guide

The SQL Procedure

[continuerule]
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

Previous Page | Next Page | Top of Page