topic Re: How to make column with each row's number in SAS Programming

How to make column with each row's number

jamie0111 — Fri, 24 Mar 2017 07:52:57 GMT

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 — Fri, 24 Mar 2017 08:03:24 GMT

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

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

jamie0111 — Fri, 24 Mar 2017 09:00:32 GMT

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

Please explain more detail??

Thanks, Jamie.

Kurt_Bremser — Fri, 24 Mar 2017 09:33:30 GMT

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