我正在尝试创建一个用sas编写的vertica视图。

proc sql;
      connect to odbc as try
     (server='10.10.7.174' port=5433 user=dbadmin password=password );
     execute (create view  &schema..myview as 

     ( Select * from &schema..table_1
       union all 
       Select * from &schema..table_2
     ))by try ;

 disconnect from try;
quit;

问题是：结果它创建了一个表而不是一个视图。