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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.