create or replace procedure testProcedure2 IS
BEGIN
  CREATE VIEW studentProf AS SELECT sname, pname, salary FROM student, professor WHERE pname=advisor; 
  -- this is invalid procedure.
  -- you can issue only DML statements in the body of procedure
END;
.
run;
