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=external-filename;
|
-
external-filename
-
lets you 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.
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, the output view has the same level of
security. However, the file that contains the SQL statements does not show
password values. The password in the LIBNAME statement also does not show
password values.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.