Chapter 7: Creating and Managing Views Using PROC SQL

  1. Correct answer: a
    A PROC SQL view accesses the most current underlying data and can be joined with tables or other views. In addition, a PROC SQL view can
    • be used in SAS programs in place of an actual SAS data file
    • be derived from one or more tables, PROC SQL views, or DATA step views.
  2. Correct answer: d
    PROC SQL views are useful because they
    • often save space (a view is usually quite small compared with the data that it accesses)
    • prevent users from continually submitting queries to omit unwanted columns or rows
    • hide complex joins or queries from users.
    In addition, PROC SQL views
    • ensure that input data sets are always current, because data is ...

Get SAS Certification Prep Guide, 4th Edition 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.

Start your free trial