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, then the procedure
moves to the next view. The PROC SQL statements that are generated by PROC
CV2VIEW 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 © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.