On Mon, 16 Apr 2007 16:48:35 -0400, data _null_; <datanull@GMAIL.COM> wrote:

>In this case where there is no MASTER the transaction data set is used >as the MASTER. Hence UPDATE have(obs=0) have; SAS is happy to have a >MASTER data set with 0 observations but it must exist, for UPDATE to >work properly.

Moreover, the satellite variables are not needed on the master side. So an even more spare implementation of this technique is

data want; update have (obs=0 KEEP = ID ) have; by id; run;

> > >On 4/16/07, Huang, JS <Huang.JS@principal.com> wrote: >> Mogens: >> >> Can you explain what role dose "obs=0" play in the update statement? >> >> Thanks, >> >> -----Original Message----- >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of >> Mogens A. Krogh >> Sent: Monday, April 16, 2007 2:56 PM >> To: SAS-L@LISTSERV.UGA.EDU >> Subject: Re: arrays >> >> Dear Sas_learner, >> The simple solution would be (learned it here on the SAS-L): >> >> data want; >> update have (obs=0) have; >> by id; >> run; >> >> regards >> Mogens A. Krogh >> PhD-student, DVM >> www.life.ku.dk >> >> >> -----Message Disclaimer----- >> >> This e-mail message is intended only for the use of the individual or >> entity to which it is addressed, and may contain information that is >> privileged, confidential and exempt from disclosure under applicable law. >> If you are not the intended recipient, any dissemination, distribution or >> copying of this communication is strictly prohibited. If you have >> received this communication in error, please notify us immediately by >> reply email to Connect@principal.com and delete or destroy all copies of >> the original message and attachments thereto. Email sent to or from the >> Principal Financial Group or any of its member companies may be retained >> as required by law or regulation. >> >> Nothing in this message is intended to constitute an Electronic signature >> for purposes of the Uniform Electronic Transactions Act (UETA) or the >> Electronic Signatures in Global and National Commerce Act ("E-Sign") >> unless a specific statement to the contrary is included in this message. >> >> While this communication may be used to promote or market a transaction >> or an idea that is discussed in the publication, it is intended to provide >> general information about the subject matter covered and is provided with >> the understanding that The Principal is not rendering legal, accounting, >> or tax advice. It is not a marketed opinion and may not be used to avoid >> penalties under the Internal Revenue Code. You should consult with >> appropriate counsel or other advisors on all matters pertaining to legal, >> tax, or accounting obligations and requirements. >>