placing created column in specific position

[chemicalab]

Hi all,

Ok maybe my question is simple but i cant seem to find if there is any solution to it,

I was just wondering when i create a new column(new variable ) in a dataset is there any command to define the place it should take instead of automatically placing it last?

lets say i calculate the sum of a few variables and i want the column that contains the sum to appear after the variables is it possible?

thnx in advance

[Ksharp]

It seems to do it ,Only after this dataset created.
Ex:
[pre]
proc report data=class nowd out=_class(drop=_break_);
column a a_sum b b_sum...
define a /display;
run;
[/pre]

The advantage of this way is that you can use sas variable list method Such as:
a1-a10 a-numeric-x a--z _character_ .........


Ksharp

[chemicalab]

Thnx Ksharp i will work my way on your advice thnx