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
              SAS dataset).
Comments: To: sashole@bellsouth.net
Content-Type: text/plain; charset="iso-8859-1"

Paul,

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.

Kind regards,

Ya
-----Original Message-----
From: Paul Dorfman [mailto:paul_dorfman@HOTMAIL.COM]
Sent: Tuesday, August 26, 2003 8:43 AM
To: SAS-L@LISTSERV.UGA.EDU
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...

Kind regards,
=================
Paul M. Dorfman
Jacksonville, FL
=================

_________________________________________________________________
Get MSN 8 and help protect your children with advanced parental controls.
http://join.msn.com/?page=features/parental