03-03-2011 08:38 AM
03-03-2011 09:29 AM
03-03-2011 09:37 AM
03-03-2011 09:43 AM
03-03-2011 07:35 PM
10-31-2016 11:56 AM - edited 10-31-2016 11:57 AM
Reeza provides the ideal solution, eliminating the need to create a new data set.
proc sql; update have1 as h1 set var2=(select var2 from have2 as h2 where h1.var1=h2.var1) where var1 in (select var1 from have2); quit;
I reckon the where statement only improves performance. If you're updating only a few values in a very large data set then this will significantly speed up the update. Definitely my favorite solution to the problem.