topic Re: Creating a Column That Groups Data Every n Rows in SAS Programming

Creating a Column That Groups Data Every n Rows

AAWTomHanks — Fri, 12 Jan 2018 00:56:53 GMT

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.

Re: Creating a Column That Groups Data Every n Rows

novinosrin — Fri, 12 Jan 2018 01:11:21 GMT

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

Re: Creating a Column That Groups Data Every n Rows

novinosrin — Fri, 12 Jan 2018 01:19:11 GMT

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;

Re: Creating a Column That Groups Data Every n Rows

AAWTomHanks — Fri, 12 Jan 2018 01:56:13 GMT

Perfect, thank you!

Re: Creating a Column That Groups Data Every n Rows

hhchenfx — Mon, 19 Mar 2018 16:21:01 GMT

Thanks a lot.

A bit shorter.

HHCFX


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