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.
data want;
set have;
member = _n_;
run;
_n_ is the number of the current iteration of the data step.
I can't understand what you mean.. sorry...
Please explain more detail??
Thanks, Jamie.
_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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.