topic Re: Please help, how to add a new id column? in SAS Procedures

Please help, how to add a new id column?

deleted_user — Mon, 24 Nov 2008 19:22:56 GMT

Hi Gurus,

Please help.

I would like to add a new ID column in existing table with the ID numbers equal the row numbers. Still don't know how.

ID
1
2
3
4
5
...

I know this is a dumb question, but.... Message was edited by: WAYNE66

Re: Please help, how to add a new id column?

Bill — Mon, 24 Nov 2008 21:07:49 GMT

The data step carries a bunch of hidden variables in the pdv that disappear at the end of the data step. To keep them, one needs to insert them into another field. The one that you are interested in is _n_;

data new;
set old;
IDNew=_n_;
run;

Re: Please help, how to add a new id column?

deleted_user — Mon, 24 Nov 2008 23:10:11 GMT

Hi Wayne,
I have come up with a (sort of) solution, but for sure soon will get the exact solution to your query. Well this is what I thought of:
If you can create an ID variable in ur raw data set just analogous to your observation and in ur PROC PRINT use 'NOOBS' option... in dat case , ur ouput wud have soemthg like this:
ID
1
2
3
.
.
10
Now this is gonna be fine with few rows ,,, how if the raw data has 100s of rows(I mean really huge data????)???
Will find out and let u know sooner.Even I am eager to know abt this...

Regards,
SAS_Learner

Re: Please help, how to add a new id column?

tejeshwar — Tue, 25 Nov 2008 11:26:05 GMT

As Bill pointed out , a perfect way to do it is to use _n_. This keeps the row number at every row. Once you have a dataset, you just need to create a new variable which is = _n_ and this will work.

Thanks