CV2VIEW Procedure
Example 3: Converting a Library of View Descriptors for All Supported
DBMSs
Features: |
PROC CV2VIEW option: DBMS=ALL
- Statements:
- PROC CV2VIEW
- FROM_LIBREF=
- TO_LIBREF=
|
In this example PROC
CV2VIEW converts all view descriptors that are in the input library
and that access data in any supported DBMS. If an error occurs during
the conversion of a view descriptor, the procedure then moves to the
next view. The PROC SQL statements that PROC CV2VIEW generates are
automatically submitted but are not saved to an external file because
the
SAVEAS=
statement is not used.
libname input '/username/descriptors/';
libname output '/username/sqlviews/';
proc cv2view dbms=all;
from_libref = input;
to_libref = output;
run;
Copyright © SAS Institute Inc. All rights reserved.