topic Re: move a column to be the first one in SAS Programming

move a column to be the first one

MarcTC — Tue, 17 May 2011 23:33:25 GMT

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?

Re: move a column to be the first one

Ksharp — Wed, 18 May 2011 10:25:35 GMT

Then Should use this;
[pre]

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

Ksharp

Re: move a column to be the first one

stateworker — Wed, 18 May 2011 16:39:16 GMT

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

Re: move a column to be the first one

stateworker — Wed, 18 May 2011 16:41:07 GMT

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

Re: move a column to be the first one

SUN59338 — Wed, 18 May 2011 18:37:08 GMT

length or format statement works also.