|
On Wed, 15 Jul 2009 22:43:45 -0400, Harry <dj_epw@YAHOO.COM> wrote:
>Hi,
>
>I am trying to update a Master table with values from a reference table.
>
>Given the master table has 12 million observations - what would be the
>fastest way of updating?
>
>1) Building a macro list from reference table to update master table?
>2) Joining the two tables?
>
>Thanks
>Harry
I assume that
data master;
update master reference;
by key;
run;
might be one of the fastest ways.
Gerhard
|