
Overview
What Is the SQL Procedure?
The SQL procedure implements Structured Query Language (SQL) for SAS. SQL is a
standardized, widely used language that retrieves data from and updates data in tables
and the views that are based on those tables.
The SAS SQL procedure enables you to do the following:
• retrieve and manipulate data that is stored in tables or views.
• create tables, views, and indexes on columns in tables.
• create SAS macro variables that contain values from rows in a query's result.
• add or modify the data values in a table’s columns or insert and delete rows. You can
also modify the table itself by adding, modifying, or dropping ...