Managing PROC SQL Views
Guidelines for Using PROC SQL Views
When you are working with PROC SQL views, it is best
to follow these guidelines:
Avoid using an ORDER BY clause
in a view definition, which causes the data to be sorted every time
the view is executed. Users of the view might differ in how or whether
they want the data to be sorted, so it is more efficient to specify
an ORDER BY clause in a query that references the view.
If the same data is used many times
in one program or in multiple programs, it is more efficient to create
a table rather than a view because the data must be accessed at each
view reference. (This table can be a temporary table in the Work library.)
Avoid creating views that are based on tables whose ...
Get SAS Certification Prep Guide, 4th Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.