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-file-name;

REPLACE=ALL | VIEW | FILE;

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

Last updated: February 3, 2026