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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.