Date: Tue, 26 Aug 2003 09:09:54 -0700
Reply-To: "Huang, Ya" <yhuang@AMYLIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Huang, Ya" <yhuang@AMYLIN.COM>
Subject: Re: Ways to code (if Var contains the value of an Obs in another
Content-Type: text/plain; charset="iso-8859-1"
I'm not sure what you mean by "macro memory search",
can you give a sample code. Is this a new trick that
has never been revealed yet.
From: Paul Dorfman [mailto:paul_dorfman@HOTMAIL.COM]
Sent: Tuesday, August 26, 2003 8:43 AM
Subject: Re: Ways to code (if Var contains the value of an Obs in
another SAS dataset).
>From: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
>>"Haynes, Zac" <ZHaynes@BCBSM.COM> wrote in message
>>What are some efficient ways to compute whether a variable ($char80.)
>>contains the value of one of the observations of another SAS dataset?
>Depends on the nature of the variables being looked up. If lookup is
>equality (col-n = v in table X is equal to col-m in table Y) than all these
>can work well:
>array, hash, format, merge, SQL left join, SQL subquery lookup
...bitmaps, conditional IN/OR/AND lists, SAS index lookup, INDEX() against a
concatenated string, binary/interpolation search with POINT=..., macro
memory search, on...
Paul M. Dorfman
Get MSN 8 and help protect your children with advanced parental controls.