The CV2VIEW Procedure TO_LIBREF= Statement 281
TO_VIEW= Statement
Specifies the name of the new (converted) view
Requirement: You must specify either the TO_VIEW statement or the TO_LIBREF
statement.
Requirement:
The FROM_VIEW and TO_VIEW statements are always used together.
Restriction:
If you specify DBMS=ALL, then you cannot use the TO_VIEW statement.
Interaction:
Use the REPLACE statement to control whether the output file is
overwritten or appended if it already exists.
TO_VIEW=libref.view-name;
Arguments
libref
specifies the libref where you will store the new PROC SQL view.
view-name
specifies the name for the new PROC SQL view that you want to create.
TO_LIBREF= Statement
Specifies the library that contains the new (converted) views
Requirement: You must specify either the TO_VIEW statement or the TO_LIBREF
statement.
Requirement: The FROM_LIBREF and TO_LIBREF statements are always used together.
Interaction: Use the REPLACE statement if a file with the name of one of your output
views already exists. If a file with the name of one of your output views already exists
and you do not specify the REPLACE statement, PROC CV2VIEW does not convert
that view.
TO_LIBREF= output-library;
Argument
output-library
specifies the name of a previously assigned library where you want to store the new
PROC SQL views.
Details
The names of the input view descriptors are used as the output view names. In order
to individually name your output views, use the FROM_VIEW statement and the
TO_VIEW statement .
