You can achieve your final goal by putting both summarisations (whole and top 3) side by side
proc sql;
select * from
(select
mean(score_game1) as mean_score1,
mean(score_game2) as mean_score2,
mean(score_game3) as mean_score3
from players) ,
(select
mean(score_game1) as mean_top_score1,
mean(score_game2) as mean_top_score2,
mean(score_game3) as mean_top_score3
from players where player_rank <= 3);
quit;
... View more
