move a column to be the first one

[MarcTC]

This is usually how I did when I want to move a column to be the first column in the dataset:


data a2;
retain idx;
set a1;
idx = _n_;
run;

Is there any better way to do this in data steps?

[Ksharp]

Then Should use this;
[pre]


data temp;
idx=_n_;
set sashelp.class;
run;
[/pre]


Ksharp

[stateworker]

I'm glad you asked this because I've needed to do this and didn't know how! Thanks!

[stateworker]

I'm glad you asked this because I've needed to do this and didn't know how! Thanks!

[SUN59338]

length or format statement works also.