8.9. Summary

  1. Views are not tables and consequently do not store data (see section 8.2).

  2. Views access one or more underlying tables (base tables) or other views (see section 8.2).

  3. Views improve the change control process when constructed as a “common” set of routines (see section 8.2).

  4. Views eliminate or reduce data redundancy (see section 8.3).

  5. Views hide unwanted or sensitive information while displaying specific columns and/or rows (see section 8.4).

  6. Views shield users from making logic and/or data errors (see section 8.5).

  7. Nesting views too deeply can produce unnecessary confusion and maintenance difficulties (see section 8.6).

  8. Updatable views add, modify, or delete rows of data (see section 8.7).

  9. Views can be deleted when no longer needed (see ...

Get PROC SQL: Beyond the Basics Using SAS® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.