SAS® Certification Prep Guide: Advanced Programming for SAS®9 Second Edition

Chapter 7. Creating and Managing Views Using PROC SQL

• Overview 244

  • Introduction 244

  • Objectives 244

  • Prerequisites 244

• Creating and Using PROC SQL Views 245

  • PROC SQL Views 245

  • Creating PROC SQL Views 245

  • Example 246

  • Using PROC SQL Views 246

• Displaying the Definition for a PROC SQL View 247

  • Example 248

• Managing PROC SQL Views 248

  • Guidelines for Using PROC SQL Views 248

  • Omitting the Libref 249

  • Using an Embedded LIBNAME Statement 249

  • Example 250

  • Creating a View to Enhance Table Security 250

  • Example 250

• Updating PROC SQL Views 251

  • Example 251

• Dropping PROC SQL Views 253

  • Example 253

• Summary 254

  • Text Summary 254

    • Using PROC SQL Views 254

    • Creating SQL Views 254

    • Displaying the Definition for a PROC SQL View 254

    • Managing PROC SQL Views 254

    • Updating PROC SQL Views 255

    • Dropping PROC SQL ...