topic Re: assigning same sequence numbers within each group in SAS Programming

assigning same sequence numbers within each group

ilikesas — Wed, 23 Nov 2016 02:13:32 GMT

Hi,

suppose that I have a table with 10 ids. Is it possible to create a new variable called "group" such that there are only say 3 groups and they are repetitive in the form 3,1,2,3,1,2,3,1,2 etc:

id	group
1	3
2	1
3	2
4	3
5	1
6	2
7	3
8	1
9	2
10	3

Thank you!

Re: assigning same sequence numbers within each group

Shmuel — Wed, 23 Nov 2016 02:47:04 GMT

Use function mode() to create the group code:

data test;

retain group 3; /* initial value, may be adapted to start with that value */

do id=1 to 10;

output;

group = mod(group,3) +1;

end;

run;

Re: assigning same sequence numbers within each group

LaurieF — Wed, 23 Nov 2016 02:38:09 GMT

Umm - I think you mean 'mod'…

Re: assigning same sequence numbers within each group

Shmuel — Wed, 23 Nov 2016 02:48:29 GMT

Thanks. You are right. it should be mod().

Re: assigning same sequence numbers within each group

ilikesas — Wed, 23 Nov 2016 02:51:15 GMT

Thanks for the code it works perfectly!

But suppsoe that instead of the groups 3,1,2 I had groups a,b,c - is it possible to have a more universal solution which can accomodate for any groups?

Re: assigning same sequence numbers within each group

LaurieF — Wed, 23 Nov 2016 03:21:50 GMT

Using the 'more than one way to skin a cat' process:

data test;
     array group_array{3} $ 1 _temporary_ ('a', 'b', 'c');
     retain groupn 2; /* initial value, may be adapted to start with that value */
     do id=1 to 10;
          groupn = mod(groupn, 3) + 1;
          group = group_array[groupn];
          output;
     end;
keep id group;
run;

Assigning the values to an array, then using the mod-ed groupn value, you get (in order) c / a / b / c…

Re: assigning same sequence numbers within each group

Ksharp — Wed, 23 Nov 2016 03:23:26 GMT


data have;
array x{3} $ _temporary_ ('c' 'a' 'b');
 do id=1 to 10;
  if mod(id,3)=1 then n=0;
  n+1;
  group=x{n};
  output;
 end;
run;

Re: assigning same sequence numbers within each group

Ksharp — Wed, 23 Nov 2016 03:29:35 GMT


data have;
array x{3} $ _temporary_ ('c' 'a' 'b');
 do id=1 to 10;
  if mod(id,3)=1 then n=0;
  n+1;
  group=x{n};
  output;
 end;
run;

Re: assigning same sequence numbers within each group

Ksharp — Wed, 23 Nov 2016 03:40:08 GMT


data have;
array x{3} $ _temporary_ ('c' 'a' 'b');
 do id=1 to 10;
  if mod(id,3)=1 then n=0;
  n+1;
  group=x{n};
  output;
 end;
run;

Re: assigning same sequence numbers within each group

ilikesas — Wed, 23 Nov 2016 03:45:58 GMT

is it possible to assign a list such that:

array x{3} $ _temporary_ &list;

Re: assigning same sequence numbers within each group

LaurieF — Wed, 23 Nov 2016 03:49:12 GMT

Yes definitely. You have to be careful as to how you construct "&list", with the quoting especially, but it would be a great generalised solution.

Re: assigning same sequence numbers within each group

ilikesas — Wed, 23 Nov 2016 04:12:02 GMT

Thanks!

Strictly speaking, Shmuel's post is the answer to the question as I formulated it, but the other posts give immense insight into the general solution!