LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 16 Jul 2009 06:03:05 -0400
Reply-To:   Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:   Re: Updating master table using a reference table

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


Back to: Top of message | Previous page | Main SAS-L page