282 CV2VIEW Procedure Examples Chapter 16
CV2VIEW Procedure Examples
Example 1: Converting an Individual View Descriptor
In this example, PROC CV2VIEW converts the MYVIEW view descriptor to a PROC
SQL view, NEWVIEW. The MYVIEW view descriptor is ALTER, READ, and WRITE
protected. The PROC SQL statements that are generated by PROC CV2VIEW are
submitted and saved to an external file named SQL.SAS.
libname input ’/username/descriptors/’;
libname output ’/username/sqlviews/’;
proc cv2view dbms=oracle;
from_view = input.myview (alter=apwd);
to_view = output.newview;
saveas = ’/username/vsql/sql.sas’;
submit;
replace file;
run;
PROC CV2VIEW generates the following PROC SQL statements.
/* SOURCE DESCRIPTOR: MYVIEW */
PROC SQL DQUOTE=ANSI;
CREATE VIEW OUTPUT.NEWVIEW
(
/* READ= */
/* WRITE= */
/* ALTER= */
LABEL=EMPLINFO
)
AS SELECT
"EMPLOYEE " AS EMPLOYEE INFORMAT= 5.0 FORMAT= 5.0
LABEL= ’EMPLOYEE ’ ,
"LASTNAME " AS LASTNAME INFORMAT= $10. FORMAT= $10.
LABEL= ’LASTNAME ’ ,
"SEX " AS SEX INFORMAT= $6. FORMAT= $6.
LABEL= ’SEX ’ ,
"STATUS " AS STATUS INFORMAT= $9. FORMAT= $9.
LABEL= ’STATUS ’ ,
"DEPARTMENT" AS DEPARTME INFORMAT= 7.0 FORMAT= 7.0
LABEL= ’DEPARTMENT’ ,
"CITYSTATE " AS CITYSTAT INFORMAT= $15. FORMAT= $15.
LABEL= ’CITYSTATE ’
FROM _CVLIB_."EMPLINFO"
USING LIBNAME _CVLIB_
Oracle
/* PW= */
USER=ordevxx PATH=OracleV8 PRESERVE_TAB_NAMES=YES;
