CV2VIEW Procedure

See: CV2VIEW Procedure

Syntax

PROC CV2VIEW DBMS=dbms-name | ALL;
FROM_VIEW=libref.input-descriptor;
FROM_LIBREF=input-library;
TO_VIEW= libref.output-view;
TYPE= SQL | VIEW | ACCESS;
TO_LIBREF= name of output library;
SAVEAS=external filename;
REPLACE=ALL | VIEW | FILE;

Table of Procedure Tasks

Statement Task
PROC CV2VIEW Statement Convert SAS/ACCESS view descriptors into SQL views
FROM_LIBREF= Statement Specify the library containing the view descriptors or access descriptors that you want to convert
FROM_VIEW= Statement Specify the view descriptor or access descriptor that you want to convert
REPLACE= Statement Specify whether existing views and files are replaced
Save the generated PROC SQL statements to a file
SAVEAS= Statement Submit the generated PROC SQL statements when you specify the SAVEAS= statement
Specify the name of the new (converted) SQL view
TO_VIEW= Statement Specify the library that contains the new (converted) SQL views
TYPE= Statement Specify what type of conversion should occur