I have a large dataset. I want to add an ID variable in the data. For every 250 rows, I want them to have the same ID. that is, for the first 250 rows, I want ID=1; the next 250 rows, I want ID=2; then then next 250 rows, ID=3; etc.
What's the efficient SAS code to help me do that?
Thanks!
data want;
set have curobs=n;
if mod(n,250)=1 then id+1;
run;
data want;
set have curobs=n;
if mod(n,250)=1 then id+1;
run;
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.
Ready to level-up your skills? Choose your own adventure.