Add a serial number column to the data

Saurabh_Rana — Tue, 08 Dec 2020 18:20:34 GMT

I have a dataset with 100k rows, I want to add a column with serai number from 1 to 100k, but I want to write the code which is dynamic i.e.it should work with a dataset of any size (for example 1000 rows, 5000 rows, etc)

Re: Add a serial number column to the data

Reeza — Tue, 08 Dec 2020 18:24:09 GMT

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

Use the automatic variable _n_ to add it easily in to your data set. You can also do it via a more manual counter if you need to count by groups or something.

https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/

topic Add a serial number column to the data in SAS Programming

Add a serial number column to the data

Re: Add a serial number column to the data