I have a table with 16 million rows and I would to add a column to the table which I did with : proc sql; alter table A add green num format 8. quit; The problem I have now is that I want the columns to be in a specific order. Let's say that I want the new column to be the first one when you read from left. Does anyone have a clue about how I can do that without creating a new table or read up the whole dateset again(because it takes about one hour)? Thanks in advance.
... View more