Chapter Contents

SAS/ACCESS Software for Relational Databases: Reference

Introduction

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 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 doesn't apply to DBMS tables.
send DBMS-specific SQL statements to a database management system (DBMS) and to retrieve DBMS 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]

Chapter Contents
Previous
Next
Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.