The CV2VIEW Procedure |
Interaction: | If you specify the SAVEAS= statement, the generated SQL is not automatically submitted, so you must use the SUBMIT statement. |
SAVEAS=external-filename; |
Argument |
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.
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, 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.