Solved
Contributor
Posts: 39

# Creating a Column That Groups Data Every n Rows

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.

Accepted Solutions
Solution
‎01-11-2018 08:56 PM
PROC Star
Posts: 1,571

## Re: Creating a Column That Groups Data Every n Rows

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;

All Replies
PROC Star
Posts: 1,571

## Re: Creating a Column That Groups Data Every n Rows

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

Solution
‎01-11-2018 08:56 PM
PROC Star
Posts: 1,571

## Re: Creating a Column That Groups Data Every n Rows

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;

Contributor
Posts: 39

## Re: Creating a Column That Groups Data Every n Rows

Perfect, thank you!

Super Contributor
Posts: 503

## Re: Creating a Column That Groups Data Every n Rows

Thanks a lot.

A bit shorter.

HHCFX

``````
data want;
set have;
retain grp 1;
if mod(n,100)=0 then grp+1;
run;
``````
☑ This topic is solved.