Structured Query Language (SQL) is a standardized, widely used language that retrieves and updates data in tables and views based on those tables. If you're familiar with SQL, you can quickly create queries in SAS by using the SQL procedure in Base SAS.
PROC SQL is the SAS implementation of SQL. When you want to examine relationships between data values, subset your data, or compute values, the SQL procedure provides an easy, flexible way to analyze your data. Using PROC SQL, you can
You can use SAS language elements such as global statements, data set options, functions, informats, and formats with PROC SQL just as you can with other SAS procedures. However, because PROC SQL implements Structured Query Language, it works somewhat differently from other Base SAS procedures.
This task focuses on retrieving data from a single table (data set). For details on joining tables, see Join tables.
You can create SQL queries using a point-and-click interface.
You can view and save the PROC SQL code that the SQL Query window generates.