topic Re: Lookup values in another column in SAS Programming

values in another column

Sudtej — Sat, 09 May 2015 12:22:57 GMT

Hi All,

I have a data with the unique player id's and their info(v1,v2,v3)

Also there is another column which shows if the player is playing in group(player_grp)

Player can play solo and/or play in the group.

for ex.

Have
player_id	player_grp	v1	v2	v3
10	10	2	3	4
11	11 10	1	4	6
12	12 13	2	6	8
13	13 12	3	7	9

Re: Lookup values in another column

Ksharp — Sat, 09 May 2015 13:56:14 GMT

data have;
infile cards expandtabs truncover;
input player_id     $ player_grp & $10.     v1     v2     v3;
cards;
10     10         2     3     4
11     11 10      1     4     6
12     12 13      2     6     8
13     13 12      3     7     9
;
run;

proc sql;
create table want as
 select a.player_id,a.player_grp,mean(b.v1) as v1,mean(b.v2) as v2,mean(b.v3) as v3
  from have as a,have as b
   where findw(a.player_grp,strip(b.player_id))
    group by a.player_id,a.player_grp;
quit;

Xia Keshan

Re: Lookup values in another column

Sudtej — Sun, 10 May 2015 06:08:11 GMT

Thank a lot Xia KEshan