DATA Step, Macro, Functions and more

How to make column with each row's number

Reply
Occasional Contributor
Posts: 9

How to make column with each row's number

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.

 

Super User
Posts: 6,939

Re: How to make column with each row's number

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 9

Re: How to make column with each row's number

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

Please explain more detail??

 

Thanks, Jamie.

Super User
Posts: 6,939

Re: How to make column with each row's number

_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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 129 views
  • 0 likes
  • 2 in conversation