Date: Wed, 27 Nov 2002 15:54:16 -0500
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: like vs. contains vs. index
Content-Type: text/plain; charset="iso-8859-1"
The LIKE operator supports rudimentary pattern-matching. CONTAINS (or ?)
checks for a substring on the LHS that matches exactly a sting on the RHS.
The INDEX() function searches for the postion of the first character in a
character string of a substring that matches the second argument of the
function. (In the future SAS will also offer a fuzzy index function.)
From: Nick Paszty [mailto:paszty@XOMA.COM]
Sent: Tuesday, November 26, 2002 4:12 PM
Subject: like vs. contains vs. index
solaris, SAS v 8.2.
appart from being able to use index in a where and subsetting if, what
is the difference between using these operators or function?