CREATE OR REPLACE TRIGGER InsertMyView INSTEAD OF INSERT ON studentProf 
FOR EACH ROW
BEGIN
  INSERT INTO Student(sName, advisor) VALUES (:new.student, :new.professor);
END;
.
run;
