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 |
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
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
Thank a lot Xia KEshan
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.