The CV2VIEW Procedure |
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.