DATA Step, Macro, Functions and more

Creating a Column That Groups Data Every n Rows

Accepted Solution Solved
Reply
Contributor
Posts: 39
Accepted Solution

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

Posted in reply to novinosrin

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;

View solution in original post


All Replies
PROC Star
Posts: 1,571

Re: Creating a Column That Groups Data Every n Rows

Posted in reply to AAWTomHanks

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

Posted in reply to novinosrin

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

Posted in reply to novinosrin

Perfect, thank you!

Super Contributor
Posts: 503

Re: Creating a Column That Groups Data Every n Rows

Posted in reply to novinosrin

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 165 views
  • 0 likes
  • 3 in conversation