The SAS SQL procedure
enables you to retrieve and update
ADABAS data. You can retrieve and browse
ADABAS data by specifying a view descriptor
in a PROC SQL SELECT statement.
To update the data,
you can specify view descriptors in the PROC SQL DELETE, INSERT, and
UPDATE statements. You must have access to the data through appropriate
ADABAS and NATURAL security options
before you can edit
ADABAS data. Here is a summary of the pertinent PROC SQL statements:
deletes logical records
from an ADABAS file.
inserts logical records
in an ADABAS file.
retrieves and displays
data from an ADABAS file.
A SELECT statement is usually referred to as a query because it queries
the ADABAS file for information.
updates values in an ADABAS file.
When using the SQL procedure,
note that the data is displayed in the
SAS OUTPUT window. The procedure displays output data automatically without
using the PRINT procedure and executes without using the RUN statement
when an SQL procedure statement is executed.