ORA-24333: zero iteration count 
Cause: An iteration count of zero was specified for the statement. 

// *Action: Specify the number of times this statement must be executed

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;