|SAS/ACCESS Software for Relational Databases: Reference
Version 7 and later, the SQL Procedure has several enhancements
to the ways in which it interacts with SAS/ACCESS software.
- After you assign a libref to a relational DBMS
(RDBMS) using the SAS/ACCESS LIBNAME statement, you can reference this new
libref in a PROC SQL statement to query, update, or delete RDBMS data.
- You can embed LIBNAME information in a PROC SQL
view by using the new USING LIBNAME syntax; therefore, every time the PROC
SQL view is processed, you automatically connect to the RDBMS and can access
its data. For more information, see the SQL Procedure's CREATE VIEW statement
in SAS Procedures Guide.
- In the Pass-Through Facility's CONNECT statement,
you can now specify arguments that indicate whether a connection to a relational
database is unique or shared, whether you want to be prompted by a window
in order to enter your DBMS-specific connection information, and so on. For
more information, see CONNECT Statement Arguments
- You can specify a simple PROC SQL view--a
view that is based on one table--in any SAS application to update, insert,
or delete the view's underlying data. For an example of this new feature,
see the SQL Procedure's UPDATE statement in SAS Procedures Guide.
- Joins are passed to the RDBMS to process whenever
possible. For example, before implementing a join, PROC SQL checks to see
if the RDBMS can do the join. If it can, PROC SQL passes the join to the RDBMS.
This increases performance by reducing data movement and translation.
- You can use the DQOUTE=ANSI option to enable you
to use names that are not normally permissible in SAS as table names or column
- You can use the DBINDEX= and DBKEY= data set options
to specify an index name or the column names that make up the index in order
to improve performance. For more information, see SAS/ACCESS Data Set Options.
Using DBMS Data in Version 7 and Version 8
for additional examples of easier and more direct ways of using DBMS data
in SAS/ACCESS software in Version 7 and later.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.