Sometimes you need quick answers to questions about your data. You may want to query your data to

• examine relationships between data values
• view a subset of your data
• compute values quickly.

For queries such as these, the SQL procedure (PROC SQL) provides an easy, flexible way to analyze your data. This lesson shows you how to create a basic query using one or more tables (data sets).

In this lesson, you learn to

• invoke the SQL procedure
• select columns
• define new columns
• specify the tables(s) to be read
• specify subsetting criteria
• order rows by values of one or more columns
• end the SQL procedure.

Prerequisites

Before taking this lesson, you should have completed the following lessons:

Introduction to SAS Programming

• Working in the SAS Environment
• Basic Concepts
• Editing and Debugging SAS Programs
• Setting Up Your SAS Session