This is my code so far: /* Read in data */
options validvarname=v7;
libname NBA xlsx "~/L.E.B.R.O.N. Framework/data/2012_data.xlsx";
*libname NBA clear;
/* Test printing data */
*proc print data=nba.player_usage;
*run;
proc sql;
create table player_traditional_usage_merged as
select a.player, a.team, a.age, a.gp, a.w, a.l,
a.min, a.pts, a.oreb, a.dreb, a.ast,
a.stl, a.blk, b._pts, b._oreb, b._dreb,
b._ast, b._stl, b._blk
from nba.player_traditional a inner join nba.player_usage b
on a.player = b.player
and a.team = b.team
and a.age = b.age
and a.gp = b.gp
and a.w = b.w
and a.l = b.l;
quit;
proc print data=player_traditional_usage_merged;
run;
data player_traditional_usage_merged;
set player_traditional_usage_merged;
'Similarity to LeBron'n = ?
run; I am trying to calculate this Similarity to LeBron column. For this, I would need to subtract all other values from LeBron's values. In R, this would look something like the following: player_traditional_usage_merged$`Similarity to LeBron` <- player_traditional_usage_merged$PTS - player_traditional_usage_merged$PTS[player_traditional_usage_merged$PLAYER == "LeBron James"] What the above R code does is take LeBron's points value and subtract it from every player's points value in the dataset. I am trying to accomplish the same in SAS. Any insight is appreciated, thanks.
... View more