How to make column with each row's number

[jamie0111]

Hi, there.

I have big data(exactly 2,770,880 rows and more than 200 columns).

I want to make column name member with each rows number.

The result will be

     column A        column B       ......       member

1.   245                    250                              1

2.   250                   255                               2

3.    255                   260                              3

4.    260                   270                              4

        ...                     ...                                 ...

Any help and tips will be much appreciated!

Thanks, Jamie.

[Kurt_Bremser]

data want;
set have;
member = _n_;
run;

_n_ is the number of the current iteration of the data step.

[jamie0111]

I can't understand what you mean.. sorry...

Please explain more detail??

Thanks, Jamie.

[Kurt_Bremser]

_n_ is an automatic variable that you get in a data step that counts up everytime the data step jumps from the end to the top of the code.

This can be used to create a unique ascending number, as you wanted.