Data step update by equivalent in Proc sql

[rz9]

What would be the equivalent in proc sql of the update by in the data step?

Data Step:
data dataset3;
update dataset1 dataset2;
by id;
run;

Proc Sql:
???

Thank you!