Dropping PROC SQL Views

Overview

To drop (delete) a view, use the DROP VIEW statement.
General form, DROP VIEW statement:
DROP VIEW view-name-1 <,...view-name-n>;
Here is an explanation of the syntax:
view-name
specifies a SAS data view of any type (PROC SQL view or DATA step view) and can be one of the following:
  • a one-level name
  • a two-level libref.view name
  • a physical pathname that is enclosed in single quotation marks.

Example

The following PROC SQL step drops the view Sasuser.Raisev. After the step is submitted, a message appears in the SAS log to confirm that the view has been dropped. 
proc sql;
   drop view sasuser.raisev;
Table 7.4 SAS Log 
21   proc sql;
22      drop view sasuser.raisev;
NOTE: View SASUSER.RAISEV ...

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