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 has been dropped.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.135.202.203