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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.