To drop any columns in the new table, you can specify the DROP= data set option in the CREATE TABLE statement. The specified columns are dropped when the table is created. Indexes are not copied to ...

Search titles only By: Search Advanced search… ...

Inserting via plain SQL INSERT-Statement works fine as well (but I have to insert a couple thousand rows, which seemed to bit a bit slow via a genereated plain INSERT statement (even with insertin ...

You cannot change a character column to numeric and vice versa. To change a column's data type, drop the column and then add it (and its data) again, or use the DATA step. Note: You cannot change the ...