Update group value

Rohit_1990 — Fri, 22 Feb 2019 19:01:54 GMT

Hi Everyone,
In given dataset we have C1 as party and C2 as group name.
C1 C2
1 A
2 A
3 A
4 B
3 B
5 B
1 C
6 C

Now as we see we have multiple group assigned to different parties for eg party 1 is part of group of A and C as well.

Now let's say we have data as follow:

C1
1
2
3
4
5
6

We need to assign group names to each one of them but some parties have multiple group names I will assign it the max of group they are part of.

So it would be like this.
C1 C2
1 C
2 A
3 B
4 B
5 B
6 C

But in case if any group is singular then in that case the group value has to be updated to group value of the other elements of its previous group .

So party 2 was associated with 1 and 3 but now since now 1 has group value as C and 3 has B.

Hence group value must be B or C for pary 2.

So final data would be like this.

C1 C2
1 C
2 B or C
3 B
4 B
5 B
6 C

Re: Update group value

Ksharp — Sat, 23 Feb 2019 11:20:42 GMT

If I understood right.

data x;
input C1 C2	$;
cards;
1 A
2 A
3 A
4 B
3 B
5 B
1 C
6 C
;
run;
proc sql;
create table temp as
select c1,max(c2) as c2,count(*) as n
 from x
  group by c1
   order by c1;
quit;
data want;
 set temp;
 length lag $ 40;
 retain lag;
 lag=lag(c2);
 if n=1 and _n_ ne 1 then do;
  if lag>c2 then c2=lag;
 end;
 drop n lag;
run;

topic Update group value in SAS Programming

Update group value

Re: Update group value