Chapter Contents
Previous
Next
The SQL Procedure
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
Chapter Contents
Previous
Next
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.