Creating a Column That Groups Data Every n Rows

[AAWTomHanks]

Hi,

I am looking to create a new column that groups my data every n rows. For example I have 1,000 rows, I would like to create a column that assigns the first 100 rows Group 1, the next 100 rows Group 2, and so on until the final row.

Does anyone know how to accomplish this?

Thanks.

[novinosrin]

data wantttt;
grp=1;
do n=1 to 1000;
if mod(n,100)=0 then do; output;grp+1;end;
else output;
end;
run;

[novinosrin · Accepted solution]

same story but when reading a dataset:

data have;
do n=1 to 1000;
output;
end;
run;

data want;
set have;
retain grp 1;
if mod(n,100)=0 then do; output;grp+1;end;
else output;
run;

[AAWTomHanks]

Perfect, thank you!

[hhchenfx]

Thanks a lot.

A bit shorter.

HHCFX

data want;
set have;
retain grp 1;
if mod(n,100)=0 then grp+1;
run;