280 SAVEAS= Statement Chapter 16
SAVEAS= Statement
Saves the generated PROC SQL statements to a file
Interaction: If you specify the SAVEAS= statement, the generated SQL is not
automatically submitted, so you must use the SUBMIT statement.
SAVEAS=filename;
Argument
filename
enables you to save the PROC SQL statements that are generated by PROC
CV2VIEW to an external file. You can modify this file and submit it on another
platform.
Details
PROC CV2VIEW inserts comments in the generated SQL to replace any statements
that contain passwords. For example, if a view descriptor is READ, WRITE, or ALTER
protected, then the output view has the same level of security. However, the file that
contains the SQL statements does not show the password values. This is also the case
for the password in the LIBNAME statement.
SUBMIT Statement
Causes PROC CV2VIEW to submit the generated PROC SQL statements when you specify the
SAVEAS statement
Tip: If you do not use the SAVEAS= statement, PROC CV2VIEW automatically submits
the generated SQL, so you do not need to specify the SUBMIT statement.
SUBMIT;
