
• You cannot update a view that contains an ORDER BY.
Note: Beginning with SAS 9, PROC SQL views, the pass-through facility, and the
SAS/ACCESS LIBNAME statement are the preferred ways to access relational
DBMS data. SAS/ACCESS views are no longer recommended. You can convert
existing SAS/ACCESS views to PROC SQL views by using the CV2VIEW
procedure. For more information, see “CV2VIEW” in SAS/ACCESS for Relational
Databases: Reference.
Using the Output Delivery System with PROC
SQL
The Output Delivery System (ODS) enables you to produce the output from PROC SQL
in a variety of different formats such as PostScript, HTML, or list output. ODS defines ...