| SAS/ACCESS Software for Relational Databases: Reference |
The SQL procedure implements the Structured Query Language (SQL) for the SAS
System. SQL is a standardized, widely used language that retrieves and updates
data in tables and views based on those tables.
The SAS System's SQL procedure enables you to
- retrieve and manipulate data that
is stored in
tables or views.
- create tables, views, and indexes (other than
relational DBMS indexes) on SAS variables in SAS data sets.
- 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 columns, although this does not apply to relational
DBMS tables.
- send DBMS-specific SQL statements to a relational
database management system (RDBMS) and to retrieve RDBMS data.
- create SAS macro variables that contain values
from rows in a query's result.
PROC SQL Input and Output
summarizes the variety of source material that you can use with PROC SQL and
what the procedure can produce:
PROC SQL Input and Output
![[IMAGE]](./images/01329712.gif)
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
