Hello New to SAS and new to the forum I am just wondering if There is a way to update a table using a inner join. Proc SQL;
update AllDataSimple
set AllDataSimple.gasprice = forward_gasprices.price
from AllDataSimple
inner join work.forward_gasprices
on forward_gasprices.DeliveryDate = AllDataSimple.DeliveryDate
where forward_gasprices.DeliveryDate > today()-1
;
QUIT SAS only highlights UPDATE and SET and I get an error: Expecting an =. (affected code set AllDataSimple.gasprice = forward_gasprices.price) When I search for a solution the error only came up when there was a syntax error and I am sorry if that is the case but it really seems to me like SAS just doesn't like the from or inner join and the set.
... View more