Updating Table with New Variable in SAS Sql

Steelersgirl — Mon, 11 Feb 2019 15:04:00 GMT

I am trying to update a table in SAS with a new variable. I want the salary column to be multiplied by different numbers depending on position. This is the code I have been using, but it giving me an error saying that modsal isn't a variable and also giving an error when I am trying to set the position to the number I am multiplying by saying there is a syntax error.

PROC sql;
UPDATE work.baseball2
SET modsal = salary*case label ="Modern Salary Equivelent"
WHEN position = 'C' then 5
WHEN position = ('1B','2B','SS','3B') then 6
WHEN position =  ('RF','LF','CF','DH') then 8
END;

Re: Updating Table with New Variable in SAS Sql

novinosrin — Mon, 11 Feb 2019 15:06:52 GMT

this part definitely needs correction

WHEN position = 'C' then 5
WHEN position in ('1B','2B','SS','3B') then 6
WHEN position in  ('RF','LF','CF','DH') then 8

topic Updating Table with New Variable in SAS Sql in SAS Programming

Updating Table with New Variable in SAS Sql

Re: Updating Table with New Variable in SAS Sql