The following error is returned from Oracle when using the "select from connection" construction to send a query/statement with no result set to Oracle:

ORA-24333: zero iteration count

Examples of such a queries could be CREATE, ALTER, SET, etc.

In order to avoid the error you should use "execute ( ) by oracle" instead:

proc sql;
   connect to oracle (user=scott pw=tiger);
   execute (
     create table newemp as select * from emp
   ) by oracle;
   disconnect from oracle;
 quit;